Requirement: I need to get rows from a table within a given range
Solution:
select rownum, empno, ename from emp where rowid in
(select rowid from emp where rownum <=&upto
minus
select rowid from emp where rownum<&Start);
Enter value for upto: 10
Enter value for Start: 7
This query will give you rows between 7 & 10
No comments:
Post a Comment