MySQLのお勉強!

MySQL TOP

3.6.1 カラムの最大値

もっとも大きい品番は?

SELECT MAX(article) AS article FROM shop;

+---------+
| article |
+---------+
|       4 |
+---------+