create table table_B(noname varchar(20))
insert into table_B select '1'
insert into table_B select '张三'
insert into table_B select '2'
insert into table_B select '李四'select identity(int,0,1) as id,noname into #t from table_Bselect
id =max(case id%2 when 0 then noname end),
name=max(case id%2 when 1 then noname end)
from
#t
group by
id/2/*
id name
-------------------- --------------------
1 张三
2 李四
*/drop table table_B,#t
insert into table_B select '1'
insert into table_B select '张三'
insert into table_B select '2'
insert into table_B select '李四'select identity(int,0,1) as id,noname into #t from table_Bselect
id =max(case id%2 when 0 then noname end),
name=max(case id%2 when 1 then noname end)
from
#t
group by
id/2/*
id name
-------------------- --------------------
1 张三
2 李四
*/drop table table_B,#t
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货