累積分布値を返します。
構文
CUME_DIST() OVER (w)使用例
下記の値を入力するとサンプルに即時反映されます。
employee_id→salary→cume→employees→-- 누적 분포 (해당 급여 이하 비율)
SELECT employee_id, salary,
ROUND(CUME_DIST() OVER (ORDER BY salary), 4) AS cume
FROM employees;
累積分布値を返します。
CUME_DIST() OVER (w)下記の値を入力するとサンプルに即時反映されます。
employee_id→salary→cume→employees→-- 누적 분포 (해당 급여 이하 비율)
SELECT employee_id, salary,
ROUND(CUME_DIST() OVER (ORDER BY salary), 4) AS cume
FROM employees;