Skip to main content

MAX

Aggregate function.

The MAX() function returns the maximum value in a set of values.

Syntax​

MAX(expression)

Arguments​

ArgumentsDescription
expressionAny expression

Return Type​

The maximum value, in the type of the value.

Examples​

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

mysql> SELECT MAX(number) FROM numbers(3);
+-------------+
| max(number) |
+-------------+
| 2 |
+-------------+

mysql> SELECT MAX(number) AS max FROM numbers(3);
+------+
| max |
+------+
| 2 |
+------+