[DB-SIG] Select question

Conrad Koziol arkamir at softhome.net
Wed Jan 21 19:07:48 EST 2004


This isnt really about python but I was hoping you could help me with a
tricky select question. The problem I have is that I need to select a
distinct item from column A, but it has to be the item with the greatest
value in C. So if column A holds all the birthdays of joes and bobs, I
need to select the joe and bob with the closest birthday(youngest). I am
using MySQL 4.0.15.

Thanks a lot!!
	Conrad




More information about the DB-SIG mailing list