SQL ManualSQL FunctionsAggregate FunctionsMAXOn this pageMAXMAXdescriptionSyntaxMAX(expr)Returns the maximum value of an expr expressionexampleMySQL > select max(scan_rows) from log_statis group by datetime;+------------------+| max(`scan_rows`) |+------------------+| 4671587 |+------------------+keywordsMAX