Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
Group By, Distinct help
Thanks guys, The inner join method is simpler & it does the trick. One thing though - how efficient is this? I need to do it a few hundred times on a large table (27 million records). It's indexed & currently works very quickly, but I'm just wondering if you can see a problem with this in... -
Group By, Distinct help
Hi, Can anybody help me out with this query? Given the table below, I want to find the Surname of the youngest person called John: forename | surname | dob --------------------------------------- John | Smith | 01/05/1970 Mary | Brun | 23/11/1974 Frank...
