MAX
description
Syntax
MAX(expr)
Returns the maximum value of an expr expression
example
MySQL > select max(scan_rows) from log_statis group by datetime;
+------------------+
| max(`scan_rows`) |
+------------------+
| 4671587 |
+------------------+keywords
MAX