try this,hope it will help you.
with a as
(
select row_number() over(order by (select 1)) as rownumber,id,view1 from heview
),
b as
(
select row_number() over(order by (select 1)) as rownumber,id,view1 from a where rownumber%2 <>0
),
c as
(
select row_number() over(order by (select 1)) as rownumber,id,view1 from a where rownumber%2 =0
)
select c.id,c.view1,b.id,b.view1 from b,c where b.rownumber=c.rownumber