Deviopath › PostgreSQL

RANK vs DENSE_RANK

Medium · Window Functions

Both give tied rows the same number. RANK() then skips numbers (1, 1, 3), while DENSE_RANK() does not (1, 1, 2). You can name a window once with WINDOW w AS (...) and reuse it as OVER w.

For each game, rank players by points (highest first). Return game, player, points, rank (from RANK()) and dense_rank (from DENSE_RANK()). Sort by game, then points descending, then player.

Next: Running Revenue Total