MAX

MAX (expression)

Parameters

• expression - may be a column name, a result of another function, or a math operation.

Description

Returns the highest value. If no entries are selected, the result is NULL. Aggregates are only allowed in select statements. The returned value is of the same data type as the parameter.

Example

Get a height of the ​tallest player:

SELECT MAX(height) FROM Players;