Definition:
The Oracle COVAR_POP function returns the population covariance of a set of number pairs.
Example Syntax:
COVAR_POP(, )
SELECT t.calendar_month_number,
COVAR_POP(s.amount_sold, s.amount_sold) AS CP,
COVAR_SAMP(s.amount_sold, s.amount_sold) AS CS
FROM sales s, times t
WHERE s.time_id = t.time_id
AND t.calendar_year = 1998
GROUP BY t.calendar_month_number;
Related Links:
Related Code Snippets:
- COVAR_POP - COVAR_POP returns the population covariance of a set of number pairs. Both expr1 and e...
