Advanced Search

Return to Snippet

Revision: 71916
at March 27, 2017 11:13 by bbrumm
Initial Code 
SELECT CUME_DIST(300) WITHIN GROUP (ORDER BY fees_paid) AS cume_dist_test
FROM student;

SELECT CUME_DIST(300, 200) WITHIN GROUP (ORDER BY fees_paid, fees_required) AS cume_dist_test
FROM student;


SELECT first_name, last_name, fees_paid,
CUME_DIST() OVER (ORDER BY fees_paid) AS cume_dist_test
FROM student;


SELECT first_name, last_name, fees_paid,
CUME_DIST() OVER (PARTITION BY address_state ORDER BY fees_paid) AS cume_dist_test
FROM student;
Initial URL 
http://www.databasestar.com/oracle-cume_dist
Initial Description 
A few examples of the CUME_DIST function.
Initial Title 
Oracle CUME_DIST Function
Initial Tags 
sql, Oracle
Initial Language 
SQL