Foros del web
Iniciar Sesión
Ver originalSELECT t.id, t.distance, t.TIMEFROM tabla tINNER JOIN ( SELECT distance, MIN( TIME ) tiempoFROM tablaGROUP BY distance)t1 ON t.distance = t1.distanceAND t.TIME = t1.tiempoORDER BY t.distance