MySQL Tutorial / Examples of Common Queries / The Maximum Value for a Column
“What is the highest item number?”
SELECT MAX(article) AS article FROM shop;+---------+| article |+---------+| 4 |+---------+