December 2002
Intermediate to advanced
928 pages
85h 29m
English
PERCENTILE_CONT (pct_expr) WITHIN GROUP (ORDER BYexpr[ASC | DESC]) [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.
Must evaluate to a number between 0 and 1 that specifies the percentile value.
Common keywords and clauses: ASC, DESC.