Returns the maximum value in its argument. NULL values are ignored. If all inputs are NULL, MAX returns NULL.

Syntax

MAX(<expression>)

Parameters

ParameterDescriptionSupported input types
<expression>The expression whose maximum to determineAny type

Return Types

Same as input type

Examples

Example

This code example uses the following tournaments table:

nametotalprizedollars
The Drifting Thunderdome24,768
The Lost Track Showdown5,336
The Acceleration Championship19,274
The Winter Wilderness Rally21,560
The Circuit Championship9,739

When used on the totalprizedollars column, MAX will return the highest value, as follows:

SELECT
	MAX(totalprizedollars) as maxprize
FROM
	tournaments;

Returns

24,768

Example

MAX can also work on text or array columns, in which case it returns the lexicographically largest value. In this example, the function assesses the name column in the tournaments table.

SELECT
	MAX(name) as maxtournament
FROM
	tournaments;

Returns

The Winter Wilderness Rally