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-12 10:42:18 发布