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

​
Syntax

MAX(<expression>) [FILTER ([WHERE] <condition>)]

​
Parameters

ParameterDescriptionSupported input types
<expression>The expression whose maximum to determineAny type
<condition>An optional boolean expression to filter rows used in aggregationBOOL

​
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