Min returns the minimum value in a data set.

Syntax


MIN( [ DISTINCT | ALL ] expression)

Arguments

  • DISTINCT | ALL: Specifying the DISTINCT keyword excludes duplicate values from the calculation.

    • Specifying ALL explicitly includes all values, including duplicates.

    • ALL is the default behavior and is not required.

  • expression: The name of an expression on which to determine minimum values.

Returns

The same data type as the source data.

Additional Information

  • Multiple aggregate functions can be combined in the same query, so long as they comply with the following:

  • Only one DISTINCT keyword can be used per query. This means that if you are submitting both an AVG function and SUM function in the same query, only one can include the DISTINCT function, even though DISTINCT is supported with each function if submitted individually.

Examples


SELECT MIN(salesTotal) MYSQL.inventory.orders;

SELECT MIN(minCalc) FROM (VALUES (1), (2), (3)) AS myTable (minCalc);
-- Returns 1

SELECT MIN(DISTINCT minCalc) FROM (VALUES (2), (2), (4)) AS myTable (minCalc);
-- Returns 2