Skip to main content

MIN

Aggregate function.

The MIN() function returns the minimum value in a set of values.

Syntax​

MIN(expression)

Arguments​

ArgumentsDescription
expressionAny expression

Return Type​

The minimum value, in the type of the value.

Examples​

tip

numbers(N) – A table for test with the single number column (UInt64) that contains integers from 0 to N-1.

SELECT MIN(*) FROM numbers(3);
+--------+
| min(*) |
+--------+
|      0 |
+--------+

SELECT MIN(number) FROM numbers(3);
+-------------+
| min(number) |
+-------------+
|           0 |
+-------------+

SELECT MIN(number) AS min FROM numbers(3);
+------+
| min  |
+------+
|    0 |
+------+