Return to Snippet

Revision: 72044
at April 17, 2017 09:24 by bbrumm

Initial Code
FROM student;

SELECT VARIANCE(DISTINCT fees_paid) AS variance_test
FROM student;

SELECT first_name, last_name, fees_paid,
VARIANCE(fees_paid) OVER (ORDER BY enrolment_date) AS variance_value
FROM student;

Initial URL

Initial Description
A few examples of the VARIANCE function.

Initial Title
Oracle VARIANCE Function

Initial Tags
sql, Oracle

Initial Language