sqlserver 分组显示序号及插入新的序号

1.sqlserver 分组排序并插入序号

update Master set Master.SortID=t2.rownum 
from (
	select rownum,marginID 
	from (
			select row_number() over(partition by OrgID order by price) rownum,* from Master 
		) as t1
) as t2 
where t2.marginID=Master.marginID

2.sqlserver 分组排序

select row_number() over(partition by OrganizationID order by itemprice) rownum,* from Master_margin