每项物品的的最高价格是多少？

分类: IT文章 • 2022-07-24 00:30:47

select name, max(price) as price from shop group by name