Advanced Search

Return to Snippet

Revision: 71552
at March 1, 2017 05:45 by bbrumm
Initial Code 
SELECT STDDEV(fees_required)
FROM student;

SELECT STDDEV(DISTINCT fees_required)
FROM student;

SELECT
enrolment_date,
TO_CHAR(enrolment_date, 'MON') AS enrolment_mth,
STDDEV(fees_required) OVER (order by TO_CHAR(enrolment_date, 'MON')) AS stdev_val
FROM student;
Initial URL 
http://www.databasestar.com/oracle-stddev/
Initial Description 
A few examples of the STDDEV function.
Initial Title 
Oracle STDDEV Function
Initial Tags 
sql, Oracle
Initial Language 
SQL