摘要:
方法一:create table #Tmp (nu int, val varchar(100))insert into #Tmp values(1, 'a')insert into #Tmp values(2, 'b')insert into #Tmp values(2, 'c')insert into #Tmp values(3, 'd')insert into #Tmp values(3, 'e')insert into #Tmp values(3, 'f')select * from #Tmp;with Orign as(select ROW_NUMBER() over(partiti 阅读全文