Select min

[jurena]

prueba esta consulta

Código sql:

SELECT t.id, t.distance, t.TIME
FROM tabla t
INNER JOIN (
 
SELECT distance, MIN( TIME ) tiempo
FROM tabla
GROUP BY distance
)t1 ON t.distance = t1.distance
AND t.TIME = t1.tiempo
ORDER BY t.distance