SELECT
T2.num
FROM
(
SELECT
( @i := @i + 1 ) AS num,
T.groupName
FROM
( SELECT groupName, SUM( all_amt ) allAmt FROM app_agent WHERE `year_month` >= #{beginDateTime} AND `year_month` <= #{endDateTime} GROUP BY groupName ORDER BY allAmt DESC ) T,(
SELECT
@i := 0
) AS N
) T2
WHERE
T2.groupName = #{groupName}
第二种,临时变量
SET@i=0;SELECT(@i :=@i+1)AS num,
T.*FROM(SELECT org_name,SUM( all_amt ) allAmt FROM app_agent WHERE`year_month`>=202001AND`year_month`<=202012GROUPBY org_name ORDERBY allAmt DESC) T