Re: GROUP BY, MIN() row ordering problems!

[laptop alias]

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.