December 2002
Intermediate to advanced
928 pages
85h 29m
English
VARIANCE ([DISTINCT | ALL]expr) [OVER (analytic_clause)]
Computes the population variance of the values of a column or expression over the set of rows returned by a query or the set of rows specified by a GROUP BY clause. The population variance uses the number of rows returned by the query in the denominator.