MySQL Tutorial  /  Examples of Common Queries  /  The Maximum Value for a Column

7.1 The Maximum Value for a Column

What is the highest item number?

SELECT MAX(article) AS article FROM shop;
+---------+
| article |
+---------+
|       4 |
+---------+