SQL语句：更新一列为行号问题？

初级：

update T_PROFITSHARE set id=t1.rowId from 

(select C_TICKETID

ROW_NUMBER() over(Order by C_TICKETID) as rowId 

from T_PROFITSHARE) as t1 

where 

t1.C_TICKETID=T_PROFITSHARE.C_TICKETID 

如果需要更新的里面还有重复的字段

增加条件就行了

update T_PROFITSHARE set id=t1.rowId from 

(select C_TICKETID,A,B,

ROW_NUMBER() over(Order by C_TICKETID,A,B) as rowId 

from T_PROFITSHARE) as t1 

where 

t1.C_TICKETID=T_PROFITSHARE.C_TICKETID 

AND t1.A=T_PROFITSHARE.A 

AND t1.B==T_PROFITSHARE.B

转载于:https://blog.51cto.com/chend/1553049