sqlserver 分组修改

对一个表中的数据进行重新拍序
SELECT ID ChangeId,ConfigID,ProjectID,name, [Index]
 ,row_number () over(partition by ConfigID,ProjectID order by [index] )as number
FROM tb_SystemConfigOption
order by configid,projectid,[Index]