max

docs/en/sql-reference/sql-functions/aggregate-functions/max.md

4.1.0314 B

max

Returns the maximum value of the expr expression.

Syntax

Haskell

MAX(expr)

Examples

plain

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

keyword

MAX