Advanced Search

Oracle VARIANCE Function

/ Published in: SQL
Save to your folder(s)
A few examples of the VARIANCE function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT VARIANCE(fees_paid)
  2. FROM student;
  3.  
  4. SELECT VARIANCE(DISTINCT fees_paid) AS variance_test
  5. FROM student;
  6.  
  7. SELECT first_name, last_name, fees_paid,
  8. VARIANCE(fees_paid) OVER (ORDER BY enrolment_date) AS variance_value
  9. FROM student;

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.