AVG

Description

Syntax

AVG([DISTINCT] expr)

Used to return the average value of the selected field

Optional field DISTINCT parameters can be used to return the weighted average

example

1. mysql> SELECT datetime, AVG(cost_time) FROM log_statis group by datetime;
2. +---------------------+--------------------+
3. | datetime            | avg(`cost_time`)   |
4. +---------------------+--------------------+
5. | 2019-07-03 21:01:20 | 25.827794561933533 |
6. +---------------------+--------------------+

8. mysql> SELECT datetime, AVG(distinct cost_time) FROM log_statis group by datetime;
9. +---------------------+---------------------------+
10. | datetime            | avg(DISTINCT `cost_time`) |
11. +---------------------+---------------------------+
12. | 2019-07-04 02:23:24 |        20.666666666666668 |
13. +---------------------+---------------------------+

keyword

AVG