Posted By

bbrumm on 03/01/17


Tagged

sql Oracle


Versions (?)

Oracle STDDEV Function


 / Published in: SQL
 

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

A few examples of the STDDEV function.

  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;

Report this snippet  

You need to login to post a comment.