select * from (select * from shop order by price desc limit 999999) a GROUP BY a.shop_name;
mysql 查询 先排序后分组
最新推荐文章于 2024-02-13 21:57:41 发布
select * from (select * from shop order by price desc limit 999999) a GROUP BY a.shop_name;