Ranking queries

gistfile1.sql

-- Query 1

SELECT id, distance_in_meters from stats_workout s1
WHERE distance_in_meters > (SELECT distance_in_meters FROM stats_workout WHERE id=3)
ORDER BY distance_in_meters DESC;

-- Query 2

SELECT DISTINCT s1.id, s1.distance_in_meters from stats_workout s1
JOIN stats_workout s2 ON (s1.distance_in_meters > s2.distance_in_meters)
WHERE s2.id = 3
ORDER BY s1.distance_in_meters DESC;