MAX

Description

The MAX function returns the maximum value of the expression.

Syntax

MAX(<expr>)

Parameters

Parameters	Description
expr	The expression needs to be obtained

Return Value

Returns the same data type as the input expression.

Example

select max(scan_rows) from log_statis group by datetime;

+------------------+
| max(`scan_rows`) |
+------------------+
|          4671587 |
+------------------+