|Oracle8i SQL Reference
Release 2 (8.1.6)
Functions, 118 of 121
For information on syntax and semantics, see "Analytic Functions".
VARIANCE returns variance of expr. You can use it as an aggregate or analytic function.
Oracle calculates the variance of expr as follows:
The following example calculates the variance of all salaries in the
The query returns the cumulative variance of salary values in Department 30 ordered by hiredate.