how to get this sql statement

[dongdong]

I have a table which has three columns.
name(varchar)
birthday(int)
location(varchar)

I want to get the oldest man's name in every 'location'

how to write the sql statement?

thanks

 

[sonnysavage]

Do you have anything to handle the result? I would use this query:

SELECT * FROM table_name ORDER BY location, birthday;

I'd then loop through the result rows and print out the location, man's name, and birthday - every time the location changes.

 

[KarveR]

6 hours later and still thinking, looks like temporary table time as no straight query seems to want to provide unique location results with the correct info. ***************************************
Party on, dudes!