COVAR_SAMP returns the sample covariance of a pair of numbers.
Syntax:
COVR_SAMP(expression1, expression2)
Example:
SELECT id, COVAR_SAMP(list_price,min_price) as RESULT
FROM product_information
GROUP BY id;
Covar_samp – Oracle SQL Function
COVAR_SAMP returns the sample covariance of a pair of numbers.
Syntax:
COVR_SAMP(expression1, expression2)
Example:
SELECT id, COVAR_SAMP(list_price,min_price) as RESULT
FROM product_information
GROUP BY id;