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...