Calculate percent rank

sql

SELECT player_id,
       score,
       PERCENT_RANK() OVER (ORDER BY score) AS pct_rank
FROM leaderboard;

Explanation

Great for percentile-style reporting without manual math.

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

Fraction of rows at or below the current row.

Open In sheetsqlsame section

Use ROW_NUMBER in a subquery or CTE.