MAX
Description
Syntax:
MAX(expr)
This function returns the maximum value of expr.
Example
MySQL > select max(scan_rows) from log_statis group by datetime;
+------------------+
| max(`scan_rows`) |
+------------------+
| 4671587 |
+------------------+Keywords
MAX