Sql server对表中数据进行排序，并将序号更新至列

with CTE as  
        (  
         select *,rn=ROW_NUMBER() OVER(ORDER BY SumIncome desc)  
         from [table_name] where RecommendSum > 0  
        )  
        update CTE set PaiXu= rn