SQL ManualSQL FunctionsAggregate FunctionsMAXOn this pageMAXMAXβdescriptionβSyntaxβMAX(expr)Returns the maximum value of an expr expressionexampleβMySQL > select max(scan_rows) from log_statis group by datetime;+------------------+| max(`scan_rows`) |+------------------+| 4671587 |+------------------+keywordsβMAX