Search This Blog

Thursday 2 May 2013

Oracle Analytical Function COVAR_SAMP With Example

COVAR_SAMP
---------------------

COVAR_SAMP returns the sample covariance of a set of number pairs. You can use it as an aggregate or analytic function.
This function takes as arguments any numeric data type or any nonnumeric data type that can be implicitly converted to a numeric data type. Oracle determines the argument with the highest numeric precedence, implicitly converts the remaining arguments to that data type, and returns that data type.

Refer Example of COVAR_POP

No comments:

Post a Comment