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