Skip to main content

AVG

Aggregate function.

The AVG() function returns the average value of an expression.

Note: NULL values are not counted.

Syntax​

AVG(expression)

Arguments​

ArgumentsDescription
expressionAny numerical expression

Return Type​

double

Examples​

note
numbers(N) – A table for test with the single `number` column (UInt64) that contains integers from 0 to N-1.
mysql> SELECT AVG(*) FROM numbers(3);
+--------+
| avg(*) |
+--------+
|      1 |
+--------+

mysql> SELECT AVG(number) FROM numbers(3);
+-------------+
| avg(number) |
+-------------+
|           1 |
+-------------+

mysql> SELECT AVG(number+1) FROM numbers(3);
+----------------------+
| avg(plus(number, 1)) |
+----------------------+
|                    2 |
+----------------------+

mysql> SELECT AVG(number+1) AS a FROM numbers(3);
+------+
| a    |
+------+
|    2 |
+------+