AVG_WEIGHTED

description

Syntax

double avg_weighted(x, weight)

计算加权算术平均值, 即返回结果为: 所有对应数值和权重的乘积相累加，除总的权重和。如果所有的权重和等于0, 将返回NaN。

example

mysql> select avg_weighted(k2,k1) from baseall;
+--------------------------+
| avg_weighted(`k2`, `k1`) |
+--------------------------+
|                  495.675 |
+--------------------------+
1 row in set (0.02 sec)

keywords

AVG_WEIGHTED

AVG_WEIGHTED​

description​

Syntax​

example​

keywords​

AVG_WEIGHTED

description

Syntax

example

keywords