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.
