MySQL statistics maximum data Select Max

Statistical maximum data

SELECT MAX() FROM syntax is used to count the maximum data of a field from the data table.

Syntax:

SELECT MAX(column) FROM tb_name

This SQL syntax is used to count the maximum value of a certain numerical type field. There cannot be multiple fields in MAX().

Example:

SELECT MAX(uid) FROM user

Get query results:

4

The above is the content of MySQL statistical maximum data Select Max. For more related content, please pay attention to the PHP Chinese website (www.php .cn)!