Monday 17 September 2012

How to retrieve record number 70 from a table of 100 records?




(select * from emp
minus
select * from emp where rownum < 70)
intersect
select * from emp where rownum <=70;

No comments:

Post a Comment