5.6.1 The Maximum Value for a Column

Skip to Main Content

MySQL 8.4 Reference Manual Including MySQL NDB Cluster 8.4

5.6.1 The Maximum Value for a Column

“What is the highest item number?”

SELECT MAX(article) AS article FROM shop;

+---------+
| article |
+---------+
|       4 |
+---------+