December 2002
Intermediate to advanced
928 pages
85h 29m
English
Aggregate syntax:
PERCENT_RANK (pct_expr[,pct_expr...]) WITHIN GROUP (ORDER BYexpr[ASC | DESC][NULLS {FIRST | LAST}] [,expr[ASC | DESC] [NULLS {FIRST | LAST}]...])
Analytic syntax:
PERCENT_RANK ( ) OVER (analytic_clause)Computes an interpolated value that would fall into a specified percentile value pct_expr with respect to the ORDER BY clause. This function assumes a continuous distribution model. New with Oracle9i.
Common keywords and clauses: ASC, DESC, NULLS FIRST, NULLS LAST.