MySQL Forums
Forum List  »  Newbie

Re: GROUP BY, MIN() row ordering problems!
Posted by: laptop alias
Date: January 29, 2008 01:00PM

This one gets asked every day;

SELECT t1.* FROM results t1
LEFT JOIN results t2
ON t1.athleteid = t2.athleteid
AND t2.raceTime < t1.raceTime
WHERE t2.resultid IS NULL;

Edited 1 time(s). Last edit at 01/29/2008 01:00PM by laptop alias.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.