在mysql查询中,需要用到类似Oracle的行号rownum,
比如说查询数据并倒序,同时计算排名,
具体sql如下:
Select (@rowNum:=@rowNum+1) as rowNo,user_id ,count(user_id) as ticketCount
From user_info,
(Select (@rowNum :=0) ) b
group by user_id
order by ticketCount desc
user_info为相关业务表,
在mysql查询中,需要用到类似Oracle的行号rownum,
比如说查询数据并倒序,同时计算排名,
具体sql如下:
Select (@rowNum:=@rowNum+1) as rowNo,user_id ,count(user_id) as ticketCount
From user_info,
(Select (@rowNum :=0) ) b
group by user_id
order by ticketCount desc
user_info为相关业务表,