December 2002
Intermediate to advanced
928 pages
85h 29m
English
Aggregate syntax:
RANK (expr[,expr...]) WITHIN GROUP (ORDER BYexpr[ASC | DESC][NULLS {FIRST | LAST}] [,expr[ASC | DESC] [NULLS {FIRST | LAST}]...])
Analytic syntax:
RANK ( ) OVER (analytic_clause)As an aggregate function, computes for the row identified by the arguments to the function and the ORDER BY specification, the rank of that row among all rows of the aggregation group. As an analytic function, computes the rank of each row returned with respect to the other rows returned. 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 must match the positions of those in the ORDER BY clause.
Common keywords and clauses: ASC, DESC, NULLS FIRST, NULLS LAST.