CUME_DIST

​

Syntax

​

Window

cume_dist() OVER ([PARTITION BY key] ORDER BY ordering_key)

​

Arguments

​

Returns

• Type: DOUBLE
• Possible values: Greater than 0 and at most 1 for groups containing at least one row.
• NULL behavior: Returns a non-NULL fraction for every input row.
• Empty input: An empty input produces no rows.

​

Properties

​

Usage notes

• Peers with equal ORDER BY values share the cumulative fraction; the final peer group receives 1.
• Explicit window-frame clauses are not supported for this function.

​

Examples

​

Peer groups

WITH t("value") AS (VALUES (1), (1), (2), (2)) SELECT "value", cume_dist() OVER (ORDER BY "value") AS result FROM t ORDER BY "value";

​

Restart the calculation in each group

WITH sample(grp, row_id, v) AS (VALUES ('a', 1, 10), ('a', 2, 10), ('a', 3, 20), ('b', 4, 5))
SELECT grp, row_id, v, round(cume_dist() OVER (PARTITION BY grp ORDER BY v NULLS LAST), 6) AS result
FROM sample ORDER BY grp, row_id;