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?

Press CTRL+C to copy
SELECT MAX(article) AS article FROM shop; +---------+ | article | +---------+ | 4 | +---------+