# max()

`max(col [, ...cols])`

returns the maximum value of the provided column(s) in the input datastream. If multiple columns are provided, their values are lexically ordered as a tuple.

### Note

`max(a, b)`

is not the same as `max(a), max(b)`

. To get the maximum values of multiple columns, run a `stats`

query, e.g. `stats max(a), max(b)`

. See stats() for more information.

### Ordering

Ordering is alphabetical/lexical for strings, and numeric for numbers. If multiple columns are supplied, the ordering of the whole is evaluated lexically as a tuple, e.g. we compare the first values, then, if they're equal, we compare the second values, then, if they're equal, we compare the third values, etc.

If a field contains data of multiple types, text values are considered greater than numeric values, and numeric values are considered greater than `null`

values. E.g.:

`[1] < [2]`

`["a"] < ["aa"]`

`[1, 2] < [2, 1]`

`[1, 1] < [1, 2]`

`["ab", "a"] > ["a", "ca"]`

`["ab", 1] > ["a", 2]`

`[1, null] < [1, 2]`

## Returns

A table with one row and one column for each `col`

provided, called `@q.max[i]`

, where `i`

is the index of `col`

in the arguments. If only one `col`

was provided, the column is called `@q.max`

.

## Example

Return the maximum elapsed time for a request in the **checkout_api** service.

Last updated