What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

-- Download VARIANCE as PDF --


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;

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Leave a Reply

Your email address will not be published. Required fields are marked *


*