Monday, August 15, 2011

How to display records between two ranges

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