17,086
社区成员
发帖
与我相关
我的任务
分享
select a.单数,b.双数 from
(select id 单数,rownum rn from test where mod(id,2)=1)a
full join
(select id 双数,rownum rn from test where mod(id,2)=0)b
on a.rn=b.rn
select max(单数)单数,max(双数)双数 from(
select
case when mod(id,2)=1 then id end 单数,
case when mod(id,2)=0 then id end 双数,
row_number(partition by mod(id,2) order by id)rn
from test
)
group by rn
order by rn
select max(单数)单数,max(双数)双数 from(
select
case when mod(id,2)=1 then id end 单数,
case when mod(id,2)=0 then id end 双数,
row_number(partition by mod(id,2) order by id)rn
from test
)
group by rn
order by rn