with CTE as
(
select *,rn=ROW_NUMBER() OVER(ORDER BY SumIncome desc)
from [table_name] where RecommendSum > 0
)
update CTE set PaiXu= rn
Sql server对表中数据进行排序,并将序号更新至列
最新推荐文章于 2024-04-18 14:17:15 发布