corr

corr

corr介绍

corr(expr1, expr2) - 返回一组数字对之间的皮尔逊相关系数。

Examples:

> SELECT corr(c1, c2) FROM VALUES (3, 2), (3, 3), (6, 4) as tab(c1, c2);
 0.8660254037844387

Since: 1.6.0