Snippet Name: CUME_DIST Description: Returns the cumulative distribution of a value in a group of values. Also see:» RANK » REGR_SLOPE » VARIANCE » VAR_SAMP » VAR_POP » SUM » STDDEV_SAMP » STDDEV_POP » STDDEV » ROW_NUMBER » REGR_SYY » REGR_SXY » REGR_SXX » REGR_R2 » REGR_INTERCEPT » REGR_COUNT » REGR_AVGY » REGR_AVGX » Number Functions: RATIO_TO_REPORT » Number Functions: RANK » PERCENTILE_DISC » PERCENTILE_CONT » PERCENT_RANK » OVER PARTITION BY » NTILE » MIN » MAX » LEAD » LAST_VALUE » LAST Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 10th, 2009
Description: Returns the cumulative distribution of a value in a group of values.
Also see:» RANK » REGR_SLOPE » VARIANCE » VAR_SAMP » VAR_POP » SUM » STDDEV_SAMP » STDDEV_POP » STDDEV » ROW_NUMBER » REGR_SYY » REGR_SXY » REGR_SXX » REGR_R2 » REGR_INTERCEPT » REGR_COUNT » REGR_AVGY » REGR_AVGX » Number Functions: RATIO_TO_REPORT » Number Functions: RANK » PERCENTILE_DISC » PERCENTILE_CONT » PERCENT_RANK » OVER PARTITION BY » NTILE » MIN » MAX » LEAD » LAST_VALUE » LAST
CUME_DIST(<value>) OVER (<partition_clause> <order BY clause>) conn oe/oe SELECT job_id, last_name, salary, CUME_DIST() OVER (PARTITION BY job_id ORDER BY salary) AS CUME_DIST FROM employees WHERE job_id LIKE 'PU%';