COVAR_POP
COVAR_POP returns the population covariance of a set of number pairs.
Syntax
COVAR_POP (expression1, expression2) [ OVER (window_clause) ]
Remarks
• This function takes as arguments any numeric datatype, or any nonnumeric data type that can be implicitly converted to a numeric data type.
• This function determines the argument with the highest numeric precedence, implicitly converts the remaining arguments to that datatype, and returns that datatype.
• This function follows the ANSI SQL rules for data type precedence.
• Without a window clause, COVAR_POP is a simple aggregate function.