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.

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

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

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