Definition:
The Oracle CUME_DIST function returns the cumulative distribution of a value in a group of values. The CUME_DIST function always returns a number between 0 and 1.
Example Syntax:
CUME_DIST(<value>) OVER (<partition_clause> <order by clause>);
Example Usage:
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%';
Related Links:
Related Code Snippets:
- CUME_DIST - Returns the cumulative distribution of a value in a group of values.
