SQL · Window functions

cume_dist()

The cumulative distribution of a row, from 0 to 1.

sqlRunnable example sql course

Syntax

cume_dist() over (…)

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (10), (20))
SELECT minutes, cume_dist() OVER (ORDER BY minutes) AS distribution FROM lessons;

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