比方说表A字段A B C 列 内容是 A B C 1 O G2 2 D G5 3 Z 2C 4 D 2B ………… 现在要显示成为 A B C A B C 1 O G2 2 D G5 3 Z 2C 4 D 2B
declare @t table(A int,B char(1),C char(2)) insert @t select 1,'O','G2' insert @t select 2,'D','G5' insert @t select 3,'Z','2C' insert @t select 4,'D','2B'select * from (select * from @t where a%2 = 1) a join (select * from @t where a%2 = 0) b on a.a = b.a - 1/*A B C A B C ----------- ---- ---- ----------- ---- ---- 1 O G2 2 D G5 3 Z 2C 4 D 2B*/
内容是
A B C
1 O G2
2 D G5
3 Z 2C
4 D 2B
…………
现在要显示成为
A B C A B C
1 O G2 2 D G5
3 Z 2C 4 D 2B
insert @t select 1,'O','G2'
insert @t select 2,'D','G5'
insert @t select 3,'Z','2C'
insert @t select 4,'D','2B'select *
from (select * from @t where a%2 = 1) a
join (select * from @t where a%2 = 0) b
on a.a = b.a - 1/*A B C A B C
----------- ---- ---- ----------- ---- ----
1 O G2 2 D G5
3 Z 2C 4 D 2B*/