Quick Search:
 
 The Oracle COVAR_POP Function      [Return To Index] Jump to:  

Term: COVAR_POP

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...
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org