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 |
+---------+
MySQL Documentation Library