Oracle STDDEV Function


/ Published in: SQL
Save to your folder(s)

A few examples of the STDDEV function.


Copy this code and paste it in your HTML
  1. SELECT STDDEV(fees_required)
  2. FROM student;
  3.  
  4. SELECT STDDEV(DISTINCT fees_required)
  5. FROM student;
  6.  
  7. SELECT
  8. enrolment_date,
  9. TO_CHAR(enrolment_date, 'MON') AS enrolment_mth,
  10. STDDEV(fees_required) OVER (ORDER BY TO_CHAR(enrolment_date, 'MON')) AS stdev_val
  11. FROM student;

URL: http://www.databasestar.com/oracle-stddev/

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.