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