Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle CUME_DIST Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: CUME_DIST

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.
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 218 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?