This section contains reference documentation for the max function.
Get the maximum value in a group
MAX(colName)
These examples are based on the Batch Quick Start.
select max(homeRuns) AS value from baseballStats
73