Cheat Sheet logoCheat Sheet Today
SQLite Joins, CTEs, and Window Functions Cheatsheet/Rank rows by score

Assign rank values with ties.

Back to sheetBrowse commands
Sign in to save
Section: CTEs and window functions

Rank rows by score

sql
sql
SELECT player_id, score,
       DENSE_RANK() OVER (ORDER BY score DESC) AS leaderboard_rank
FROM scores;
Explanation

Useful for leaderboards and scoring systems.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing CTEs and window functions
Use a CTE to stage a subquery
Name an intermediate result set.
OpenIn sheetsqlsame section
Use a recursive CTE
Walk a hierarchy such as categories or folders.
OpenIn sheetsqlsame section
Assign row numbers
Rank rows within an ordered result.
OpenIn sheetsqlsame section
Compute a running total
Use SUM() OVER for cumulative metrics.
OpenIn sheetsqlsame section
Use an INNER JOIN
Return rows that match in both tables.
OpenIn sheetsql1 tag match
Use a LEFT JOIN
Keep parent rows even if the child is missing.
OpenIn sheetsql1 tag match