Cumulative distribution

sql

SELECT player_id,
       score,
       CUME_DIST() OVER (ORDER BY score) AS cume_dist
FROM leaderboard;

Explanation

`CUME_DIST` answers what share of rows are less than or equal to this one.

Learn the surrounding workflow

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

Same sheet · prioritizing Ranking functions

Unique sequence with no ties.

Open In sheetsqlsame section

Tied rows share rank and leave gaps.

Open In sheetsqlsame section

Tied rows share rank without gaps.

Open In sheetsqlsame section

Bucket ordered rows into four groups.

Open In sheetsqlsame section

Relative position from 0 to 1.

Open In sheetsqlsame section

Use ROW_NUMBER in a subquery or CTE.