max¶
Description¶
Returns the maximum value of a group of inputs.
Given one argument column, max computes the maximum of that column across a group of rows.
Given multiple columns, maxcomputes the scalar greatest value of those columns across a group of rows. In this case, max evaluates to null if any of the arguments evaluate to null.
Return type¶
value
Domain¶
This is an aggregate function (aggregates rows over a group in aggregate verbs.)
This is a window function (calculates over a group of multiple input rows using windowing.)
Categories¶
Usage¶
max(value_1, value_2, ...)
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
value |
storable |
no |
yes |
none |