MySQL 9.0 Reference Manual Including MySQL NDB Cluster 9.0

5.6.1 The Maximum Value for a Column

“What is the highest item number?” 

SELECT MAX(article) AS article FROM shop;

+---------+
| article |
+---------+
|       4 |
+---------+
MySQL Documentation Library