The MAX function returns the maximum value of the expression.
MAX(<expr>)
| Parameters | Description |
|---|---|
expr | The expression needs to be obtained |
Returns the same data type as the input expression.
select max(scan_rows) from log_statis group by datetime;
+------------------+ | max(`scan_rows`) | +------------------+ | 4671587 | +------------------+