VARIANCE

Returns the variance of an expression

VARIANCE([DISTINCT | ALL] <value>) OVER (<analytic_clause>)

conn oe/oe

SELECT last_name, salary,
VARIANCE(salary) OVER (ORDER BY hire_date) AS VARIANCE
FROM employees
WHERE department_id = 30;