select a.rank from (select *,ROW_NUMBER() over(order by integralNums desc) as rank from IntegralInfos) a where a.PersonId=xxx
https://www.cnblogs.com/firekylin/archive/2011/04/21/2023115.html