任务：找出最昂贵商品的编号、经销商和价格。Task: Find the number, dealer, and price of the most expensive article.

这可以通过子查询轻松完成：This is easily done with a subquery:

SELECT article, dealer, price
FROM   shop
WHERE  price=(SELECT MAX(price) FROM shop);

+---------+--------+-------+
| article | dealer | price |
+---------+--------+-------+
|    0004 | D      | 19.95 |
+---------+--------+-------+

另一种解决方案是使用 LEFT JOIN，如下所示：Another solution is to use a LEFT JOIN, as shown here:

SELECT s1.article, s1.dealer, s1.price
FROM shop s1
LEFT JOIN shop s2 ON s1.price < s2.price
WHERE s2.article IS NULL;

你也可以通过按价格降序排序所有行，然后使用 MySQL 特有的 LIMIT 子句只获取第一行，方法如下：You can also do this by sorting all rows descending by price and get only the first row using the MySQL-specific LIMIT clause, like this:

SELECT article, dealer, price
FROM shop
ORDER BY price DESC
LIMIT 1;