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