SqlServer 取得行号且保持数据的原序列【分组定义序号】

发布时间：2020-12-12 12:58:29 所属栏目：MsSql教程来源：网络整理

导读：declare @Base_NO NVARCHAR(30) set @Base_NO='ISO2015002' SELECT SORT=identity(int,1,1),* into #temp from GetJFBZList(@Base_NO); select t1.NO,t1.MCODE,t2.* from (select ROW_NUMBER() over (order by t.MCODE_ID) as NO,t.MCODE from ( select MCOD

declare @Base_NO NVARCHAR(30) set @Base_NO='ISO2015002' SELECT SORT=identity(int,1,1),* into #temp from GetJFBZList(@Base_NO); select t1.NO,t1.MCODE,t2.* from (select ROW_NUMBER() over (order by t.MCODE_ID) as NO,t.MCODE from ( select MCODE,MIN(SORT) AS MCODE_ID from #temp group by MCODE) t )t1 inner join #temp t2 ON t1.MCODE = t2.MCODE order by t2.SORT; drop table #temp;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!