34,593
社区成员
发帖
与我相关
我的任务
分享
select case m.number%2=1 then t1.id else '' end id,
case m.number%2=1 then t1.a else t2.c end a,
case m.number%2=1 then t1.b else '' end b
from demo t1,demo t2,master..spt_values m
where t1.id=t2.id and m.type='p' and m.number<=(select max(id) from demo)
select * from
(
select cast(id as int) id , a , b , id2 = id from demo
union all
select '' id , c a , '' b , id2 = id from demo
) t
order by id2 , case when b = '' then 2 else 1 end