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. </ul>
    • expression: The name of an expression on which to average values. expression must resolve to a value that can be averaged.
    • </ul> ## 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](/avg_aggregate_function.html) and [SUM function](/sum_aggregate_function.html) in the same query, only one can include the DISTINCT function, even though DISTINCT is supported with each function if submitted individually. ## Examples ## ```sql 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 ```