CUME_DIST OVER

​

Syntax

CUME_DIST() OVER ( [ PARTITION BY <partition_by> ] ORDER BY <order_by> [ASC|DESC] )

​

Parameters

​

Return Type

​

Remarks

• CUME_DIST takes no arguments.
• When no ORDER BY clause is specified, all rows within the partition are considered peers and CUME_DIST returns 1 for every row.
• Unlike PERCENT_RANK, the minimum value of CUME_DIST is 1/N (not 0), where N is the partition size.
• This function respects NULL values, and results will be ordered with default null ordering NULLS LAST unless otherwise specified in the ORDER BY clause.

​

Example

SELECT
    level,
    leveltype,
    maxpoints,
    CUME_DIST() OVER (PARTITION BY leveltype ORDER BY maxpoints) AS cd
FROM levels
ORDER BY leveltype, maxpoints;