拥有某个列的最大值的行
方法一：SELECT article, dealer, price FROM shop WHERE price=(SELECT MAX(price) FROM shop)
方法二：SELECT article, dealer, price FROM shop ORDER BY price DESC LIMIT 1
找出最贵物品的编号、销售商和价格
原文：http://www.cnblogs.com/dengyg200891/p/5966424.html
