minimum time....

[dallas]

Hi guys,
I have a table with the fields like athletes, events and time. I want to find the minimum time for each athlete by event. Can anyone help me please?
Thankz. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[rian]

Try the following solution:

SELECT t1.athlete, t1.event, t1.time
FROM table AS t1
LEFT JOIN table AS t1 ON t1.athlete = t2.athlete
AND t1.event = t2.event
AND t1.time > t2.time
WHERE t2.time IS NULL; -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --