本文共 341 字,大约阅读时间需要 1 分钟。
需求:对于每篇article,找出price最高的。
方法1:
SELECT s1.article, dealer, s1.priceFROM shop s1JOIN ( SELECT article, MAX(price) AS price FROM shop GROUP BY article) AS s2 ON s1.article = s2.article AND s1.price = s2.priceORDER BY article;
方法2:
select * from shop t where t.price = (select max(age) from shop where t.article = article) order by article;
转载地址:http://mihof.baihongyu.com/