Home >Database >Mysql Tutorial >MySQL statistics maximum data Select Max
MySQL statistics maximum data Select Max
- 黄舟Original
- 2016-12-27 17:33:242379browse
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)!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL statistical minimum data Select MinNext article：MySQL statistical minimum data Select Min