Oracle PL/SQL Tutorial/Statistical Functions/Cume Dist

Cume_Dist calculates the cumulative probability of a value for a given set of observations

It ranges from 0 to 1.

The general format for the CUME_DIST function is:

CUME_DIST(expr [, expr] ...) WITHIN GROUP
(ORDER BY expr [DESC | ASC] [ NULLS {FIRST | LAST }]
[, expr [DESC | ASC] [NULLS {FIRST |LAST }]] ...)