拥有某个列的最大值的行
方法一:
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
拥有某个列的最大值的行
方法一:
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