Advanced Search

Return to Snippet

Revision: 72044
at April 17, 2017 09:24 by bbrumm
Initial Code 
SELECT VARIANCE(fees_paid)
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 
http://www.databasestar.com/oracle-variance
Initial Description 
A few examples of the VARIANCE function.
Initial Title 
Oracle VARIANCE Function
Initial Tags 
sql, Oracle
Initial Language 
SQL