例:根据tab_A表中fee列值的大小进行排序并展示排名
SET @rank = 0;
SELECT
*, @rank :=@rank + 1 AS ranking
FROM
( select *
from tab_A
) SS
ORDER BY SS.fee DESC
例:根据tab_A表中fee列值的大小进行排序并展示排名
SET @rank = 0;
FROM
( select *
from tab_A
) SS
ORDER BY SS.fee DESC