拥有某个列的最大值的行

方法一:
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

无语言基础,自学python所做的各种笔记,欢迎大牛指点.