ReferenceSQL FunctionsAggregatemaxOn this pagemax Description Returns the maximum value of the expr expression. Syntax MAX(expr) Examples MySQL > select max(scan_rows)from log_statisgroup by datetime;+------------------+| max(`scan_rows`) |+------------------+| 4671587 |+------------------+ keyword MAX