Last post Apr 02, 2009 07:50 AM by TATWORTH
Mar 31, 2009 10:48 AM|marsbar1|LINK
Please, please, please can anyone help me. I have a database of childrens names, address and dob, I need a query that will return only the oldest child if more than one child live at the same address.
Mar 31, 2009 01:19 PMfirstname.lastname@example.org|LINK
For that you required isAlive bit field or doe so that you can take the results
Apr 02, 2009 07:50 AM|TATWORTH|LINK
Try a select like:
SELECT Address, MIN(Dob) FROM Child GROUP BY Address