SELECT THE ALTERNATIVE ROWS

select *from ela where (rowid,0) in (select rowid,mod(rownum,2) from ela);

select *from ela where (rowid,0) not in (select rowid,mod(rownum,1) from ela);