Returns the cumulative distribution value.
Syntax
CUME_DIST() OVER (w)Example
Enter values below to update the example in real time.
employee_id→salary→cume→employees→-- 누적 분포 (해당 급여 이하 비율)
SELECT employee_id, salary,
ROUND(CUME_DIST() OVER (ORDER BY salary), 4) AS cume
FROM employees;