ms sqlserver 两行数据合并成一行

create table #tmpData(
word nvarchar(max),
number int
)

insert into #tmpData(word,number) values('java',1297932)
insert into #tmpData(word,number) values('c#',928234)
insert into #tmpData(word,number) values('销售',4392821)
insert into #tmpData(word,number) values('会计',8794)
insert into #tmpData(word,number) values('司机',683)

 

select * from #tmpData

 

 select m.word ,m.number ,n.word ,n.number,m.row,n.row
from
(select word,number,row_number()over(order by getdate()) row from (select distinct top 20000 word, sum(number) number from #tmpData with(nolock) group by word order by number desc) a)m
  full join
(select word,number,row_number()over(order by getdate()) row from (select distinct top 20000 word, sum(number) number from #tmpData with(nolock) group by word order by number desc) b)n
on m.row+1 = n.row
 where m.row % 2=1 or n.row %2=0
 order by m.row
 
 
drop table #tmpData

 

原始数据:

 

结果: