The
MAX aggregate function.
MAX aggregate function returns the maximum value of an expression over a group of rows. It can be used as an analytic or an aggregate function. Aggregate function MAX can operate with Boolean values or can be converted to a Boolean.