Corr – Oracle SQL Function

CORR returns the coefficient of a pair of numbers.

Syntax:

CORR(expression1, expression2)

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

e.g.

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.