CORR returns the coefficient of a pair of numbers.


CORR(expression1, expression2)

Both expressions can NUMBER values or any value that can be converted to a NUMBER.


SELECT id, CORR(list_price, min_price) as RESULTS
FROM product_info
GROUP BY supplier_id

NOTE: There are other variations of CORR that use differing algorithms to calculate the result, see the Oracle SQL reference for more information on these.

Corr – Oracle SQL Function
Tagged on: