处理mysql先排序在分组
摘要:
--方法一,仅适用于低于5.7版本的MySql-- select * from (select * from shop order by price desc) a GROUP BY a.shop_name; --方法二-- select * from (select * from shop ord 阅读全文
posted @ 2020-05-06 15:29 qxandxt 阅读(562) 评论(0) 推荐(0) 编辑