MAX

description

Syntax

MAX(expr)

It returns the maximum value of the expr expression.

example

MySQL > select max(scan_rows)
from log_statis
group by datetime;
+------------------+
| max(`scan_rows`) |
+------------------+
|          4671587 |
+------------------+

keyword

MAX