December 2002
Intermediate to advanced
928 pages
85h 29m
English
Aggregate syntax:
DENSE_RANK (expr[,expr...]) WITHIN GROUP (ORDER BYexpr[ASC | DESC][NULLS {FIRST | LAST}] [,expr[ASC | DESC] [NULLS {FIRST | LAST}]...])
Analytic syntax:
DENSE_RANK ( ) OVER (analytic_clause)Computes the dense rank position of that 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 an integer > = 1, and the highest possible value is the number of unique values returned by the query. 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. Parameters are the same as for CUME_DIST