Skip to main content

max

Returns the maximum value for the records within <expr>. NULL values are ignored unless all the records are NULL, in which case a NULL value is returned.

If <n> is specified, MAX returns the N maximum values from a column, which is the same results as the regular query FROM ... ORDER BY ... DESC LIMIT n but as a variant list.

Syntax​

max( <expr> )
max( <expr>, <n> )

Returns​

The data type of the returned value is the same as the data type of the input values.

Arguments​

Required:

<expr>​

A column name, which can be a qualified name (for example, database.schema.table.column_name).

<n> (named) (optional)​

The number of maximum values to return.

Returns​

  • If <n> is not specified, MIN returns the same as the data type of the input values.
  • If <n> is specified, MIN returns an ARRAY that contains all the <n> minimum values.

Examples​

Get the maximum value:

VALUES (1), (1), (1), (4), (5), (6), (7), (8), (9), (10)
AGGREGATE max($0);
+---------+
| max($0) |
+---------+
| 10      |
+---------+

Get the maximum N value:

VALUES (1), (1), (1), (4), (5), (6), (7), (8), (9), (10)
AGGREGATE max($0, 5);
+--------------+
| max($0, 5)   |
+--------------+
| [10,9,8,7,6] |
+--------------+

Alternatively, use the named argument syntax:

VALUES (1), (1), (1), (4), (5), (6), (7), (8), (9), (10)
AGGREGATE max($0, n => 5);
+-----------------+
| max($0, n => 5) |
+-----------------+
| [10,9,8,7,6]    |
+-----------------+
On this page