MAX returns the maximum value in a data set.

Syntax

MAX( [ 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 MAX(salesTotal) FROM MYSQL.inventory.orders; SELECT MAX(maxCalc) FROM (VALUES (1), (2), (3)) AS myTable (maxCalc); -- Returns 3 SELECT MAX(DISTINCT maxCalc) FROM (VALUES (2), (2), (4)) AS myTable (maxCalc); -- Returns 4 ```