MAX
Returns the maximum value in its argument. NULL values are ignored. If all inputs are NULL, MAX returns NULL.
Syntax
MAX(<expression>)
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<expression> | The expression whose maximum to determine | Any type |
Return Types
Same as input type
Example
For this example, see the following table, tournaments:
| name | totalprizedollars |
|---|---|
| The Drifting Thunderdome | 24,768 |
| The Lost Track Showdown | 5,336 |
| The Acceleration Championship | 19,274 |
| The Winter Wilderness Rally | 21,560 |
| The Circuit Championship | 9,739 |
When used on the totalprizedollars column, MAX will return the highest value.
SELECT
MAX(totalprizedollars) as maxprize
FROM
tournaments;
Returns: 24,768
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