Posted By

bbrumm on 04/17/17


Tagged

sql Oracle


Versions (?)

Oracle VARIANCE Function


 / Published in: SQL
 

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

A few examples of the VARIANCE function.

  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;

Report this snippet  

You need to login to post a comment.