SQL · Window functions

percent_rank()

The relative rank of a row from 0 to 1.

sqlRunnable example sql course

Syntax

percent_rank() over (…)

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (10), (20), (30))
SELECT minutes, percent_rank() OVER (ORDER BY minutes) AS rank FROM lessons;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.