Variance – Oracle SQL Function

VARIANCE returns the variance of the values in expression.

Syntax:

VARIANCE(expression)

Example:

SELECT VARIANCE (COMMISSION_PCT) FROM EMP;

VARIANCE(COMMISSION_PCT)
———————————————–
.00726303