max

Aggregate function that calculates the maximum across a group of values.

Example:

If you need non-aggregate function to choose a maximum of two values, see greatest: