Cheat Sheet logoCheat Sheet Today
SQL Window Functions and CTEs/Use PERCENT_RANK and CUME_DIST

Measure relative row position inside an ordered set.

Back to sheetBrowse commands
Sign in to save
Section: Buckets and Percentiles

Use PERCENT_RANK and CUME_DIST

sql
sql
SELECT employee_id, salary,
       PERCENT_RANK() OVER (ORDER BY salary) AS percent_rank,
       CUME_DIST() OVER (ORDER BY salary) AS cumulative_distribution
FROM employees;
Explanation

Useful for reporting on distribution and percentile-like placement.

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 Buckets and Percentiles
Bucket rows with NTILE
Divide ordered rows into a fixed number of groups.
OpenIn sheetsqlsame section
Assign row numbers
Number rows within an ordered partition.
OpenIn sheetsql1 tag match
Use LAG
Read a value from the previous row in the same partition.
OpenIn sheetsql1 tag match
Rank rows
Assign ordered rankings with or without gaps.
OpenIn sheetsql1 tag match
Use LEAD
Read a value from the next row in the same partition.
OpenIn sheetsql1 tag match
Compute running total
Accumulate values across an ordered window.
OpenIn sheetsql1 tag match