Oracle SQL Practice
        from: oracle sql practice exercises with solutions - YouTube
# Select alternate records
1234567select * from (select empno, sal, rownum as rn from scott.emp order by empno) where mod(rn, 2) = 0; select * from (select empno, sal, rownum as rn from scott.emp order by empno) where mod(rn, 2) = 1;
#...
    
    more...
  









