select *, id identity(int,1,1) into #t from table1
select A.A A1, A.B B1, A.C C1, B.A A2, B.B B2, B.C C2 from table1 A
left join table1 B on A.id = B.id - 1
where A.id % 2 = 1
select A.A A1, A.B B1, A.C C1, B.A A2, B.B B2, B.C C2 from table1 A
left join table1 B on A.id = B.id - 1
where A.id % 2 = 1
,(select a from table1 where a=101) as a2
,(select b from table1 where a=101) as b2
,(select c from table1 where a=101) as c2
from table1