Oracle Database Statistical functions VARIANCE
Example
Variance measures how far a set numbers is spread out from it's mean. From practical perspective it is squared distance from its mean (center) - the bigger the number the farther the point is.
The following example would return variance of salary values
SELECT name, salary, VARIANCE(salary) "Variance"
FROM employees
