MAX

MAX

Compute the maximum value in the column/group/window. Supported on all non-semi-structured types.

Returns NULL if the input is all NULL or empty.

Note

When used as a window function with an ORDER BY clause but no window frame, ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW is used by default.