December 2002
Intermediate to advanced
928 pages
85h 29m
English
aggregate_functionKEEP (DENSE_RANK {FIRST | LAST} ORDER BYexpr[ASC | DESC][NULLS {FIRST | LAST}] [,expr[ASC | DESC] [NULLS {FIRST | LAST}]...]) [OVER (analytic_clause)]
Used in conjunction with another aggregate function (MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV) to operate on a set of values from a set of rows that rank as the FIRST or LAST rows, as specified by the ORDER BY specification. Expressions must match the positions of those in the ORDER BY clause.
MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV function.
Specifies that aggregation will occur only over those rows with minimum or maximum dense rank.
Can use only the PARTITION BY portion of the analytic clause.
Common keywords and clauses: ASC, DESC, NULLS FIRST, NULLS LAST.