Window

CUME_DIST

Snowflake

Menghitung cumulative distribution (proporsi baris <= current row).

Tipe hasil: DOUBLEDiperbarui: 6 Jan 2026

Syntax

SQL

CUME_DIST() OVER ([PARTITION BY ...] ORDER BY ...)

Fungsi ini tidak memerlukan parameter.

SQL

1 SELECT
2   product_name,
3   sales,
4   CUME_DIST() OVER (ORDER BY sales) as cume_dist
5 FROM products;

CDF untuk sales.

1	SELECT
2	product_name,
3	sales,
4	CUME_DIST() OVER (ORDER BY sales) as cume_dist
5	FROM products;