group by 与排序不能在一个查询中同时使用,但是可以嵌套使用 。比如 查询:
select * from AA where status =1 group by xxx
使用group by 以后进行排序
SET @row_number = 0;SELECT( @row_number := @row_number + 1 ) AS rank_num,t.*FROM(select * from AA where status=1 group by xxx) as t
时间:2022-05-11 12:50:04
group by 与排序不能在一个查询中同时使用,但是可以嵌套使用 。比如 查询:
select * from AA where status =1 group by xxx
使用group by 以后进行排序
SET @row_number = 0;SELECT( @row_number := @row_number + 1 ) AS rank_num,t.*FROM(select * from AA where status=1 group by xxx) as t
mysql 组内分组_[MySQL] group by 分组并进行组内排序取得最新一条
2019-09-26
mysql分组后组内排名_SQL实现group by 分组后组内排序
2019-04-10