SQL Trick: row_number() is to SELECT what dense_rank() is to SELECT DISTINCT | Hacker News Reader