sql实现rank排序（自增列）

实现功能：根据筛选条件实现排序功能

可以通过(@i:[email protected]+1)实现根据条件排序（注意：(SELECT @i:=0)必须放在末尾）

以下是图片中的sql语句：

SELECT (@i:[email protected]+1) AS ranking,recharge_list.user_id,recharge_list.rechargeAmout,recharge_list.count FROM

(

SELECT

t.user_id,t.user_phone,SUM(recharge_amout) AS rechargeAmout, COUNT(1) AS COUNT FROM recharge_list t

WHERE recharge_status=500 AND data_status=0 AND 1=1

GROUP BY t.user_id ,t.user_phone

ORDER BY rechargeamout DESC ) recharge_list,(SELECT @i:=0) AS t