MAX Function [Aggregate]

Returns the maximum expression value found in each group of rows.

Syntax

MAX ( expression
| DISTINCT column-name )

Parameter	Description
expression	The expression for which the maximum value is to be calculated. This is commonly a column name.
DISTINCT column-name	Returns the same as MAX ( expression ), and is included for completeness.

The same data type as the argument.

The following statement returns the value 138948.000, representing the maximum salary in the Employees table:

SELECT MAX ( Salary )
FROM Employees

Rows where expression is NULL are ignored. Returns NULL for a group containing no rows.