max([value: storable]+) -> value

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.

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

• Aggregate
• Window