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

-- Download STDDEV as PDF --


Returns the sample standard deviation of an expression

STDDEV([DISTINCT | ALL] <expression>) OVER (<analytic_clause>)

conn oe/oe

col stddev format 99999.999

SELECT last_name, salary,
STDDEV(salary) OVER (ORDER BY hire_date) “StdDev”
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 *


*