DEVFYI - Developer Resource - FYI

Display the records between two range?

ORACLE Interview Questions and Answers (Part 3)


(Continued from previous question...)

525. Display the records between two range?

select rownum, empno, ename from emp where rowid in (select rowid from emp where rownum <=&upto minus select rowid from emp where rownum<&Start);

(Continued on next question...)

Other Interview Questions