跳到主要内容

COVAR_POP

COVAR_POP returns the population covariance of a set of number pairs.

Syntax

COVAR_POP(expr0, expr1)

Arguments

ArgumentsDescription
expression0Any numerical expression
expression1Any numerical expression

Return Type

float64

Examples

SELECT covar_pop(number, number) FROM (SELECT * FROM numbers_mt(2) ORDER BY number ASC);
+---------------------------+
| covar_pop(number, number) |
+---------------------------+
| 0.25 |
+---------------------------+