December 2002
Intermediate to advanced
928 pages
85h 29m
English
Aggregate syntax:
CUME_DIST (expr[,expr...]) WITHIN GROUP (ORDER BYexpr[ASC | DESC][NULLS {FIRST | LAST}] [,expr[ASC | DESC] [NULLS {FIRST | LAST}]...])
Analytic syntax:
CUME_DIST ( ) OVER (analytic_clause)Computes the relative position of a row among all rows of the aggregation group for a hypothetical row identified by the arguments to the function and the ORDER BY specification. The value returned is > 0 and < = 1. All arguments to this function must evaluate to a constant expression. Expressions in the main function must match the positions of those in the ORDER BY clause.
Common keywords and clauses: ASC, DESC, NULLS FIRST, NULLS LAST.