对每项物品，找出最贵价格的物品的经销商
SELECT name, dealer, price FROM shop s1 WHERE price=(SELECT MAX(s2.price) FROM shop s2 WHERE s1.name = s2.name)
对每项物品，找出最贵价格的物品的经销商
最新推荐文章于 2020-04-21 16:12:52 发布
对每项物品，找出最贵价格的物品的经销商
SELECT name, dealer, price FROM shop s1 WHERE price=(SELECT MAX(s2.price) FROM shop s2 WHERE s1.name = s2.name)
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
309
