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;

http://www.databasestar.com/oracle-variance

A few examples of the VARIANCE function.

Oracle VARIANCE Function

sql, Oracle

SQL