Ver originalSELECT t1.nombre,t1.record FROM (SELECT nombre, record FROM tutabla ORDER BY nombre, record DESC) t1 GROUP BY t1.nombre ORDER BY t1.record DESC