Posted By

bbrumm on 03/01/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 03/01/17 05:45am

Statistics

Viewed 1140 times

Favorited by 0 user(s)

Related snippets

Oracle STDDEV Function

/ Published in: SQL

A few examples of the STDDEV function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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;