insert #t
select 1,'三1','男' union all
select 2,'三2','男' union all
select 3,'三3','男' union all
select 4,'三4','男' union all
select 5,'三5','男' union all
select 6,'三6','男' union all
select 7,'三7','男'
--select * from #t
select * from #t
left join #t table2 on table2.a=#t.a+1
where #t.a % 2 !=0
select
max(case when a%2=1 then a end)a,
max(case when a%2=1 then b end)b,
max(case when a%2=1 then c end)c,
max(case when a%2=0 then a end)a,
max(case when a%2=0 then b end)b,
max(case when a%2=0 then c end)c
from #t
group by (a+1)/2