Display The Records Between Two Range?

1.	Display The Records Between Two Range?
Answer» select rownum, empno, ENAME from emp where ROWID in (select rowid from emp where rownum <=&AMP;upto minus select rowid from emp where rownum<&Start); select rownum, empno, ename from emp where rowid in (select rowid from emp where rownum <=&upto minus select rowid from emp where rownum<&Start);

Answer»

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

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

Discussion