Advanced Search

Return to Snippet

Revision: 71936
at March 30, 2017 06:59 by bbrumm
Initial Code 
SELECT CORR(fees_paid, fees_required) AS corr_test
FROM student;

SELECT first_name, last_name,
CORR(fees_paid, fees_required) OVER (ORDER BY first_name) AS corr_value
FROM student;
Initial URL 
http://www.databasestar.com/oracle-corr
Initial Description 
A few examples of the CORR function.
Initial Title 
Oracle CORR Function
Initial Tags 
sql, Oracle
Initial Language 
SQL