Skip to content

Latest commit

 

History

History
33 lines (24 loc) · 611 Bytes

array_avg.md

File metadata and controls

33 lines (24 loc) · 611 Bytes
Raw

array_avg

description

Syntax

array_avg(array(type))

求取一个ARRAY中的所有数据的平均数，返回这个结果。

example

mysql> select array_avg([11, 11, 12]);
+-----------------------+
| array_avg([11,11,12]) |
+-----------------------+
| 11.333333333333334    |
+-----------------------+

mysql> select array_avg([11.33, 11.11, 12.324]);
+---------------------------------+
| array_avg([11.33,11.11,12.324]) |
+---------------------------------+
| 11.588                          |
+---------------------------------+

keyword

ARRAY_AVG,ARRAY