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 --