We can get the first 5 records by the following sql:(Let the table is emp)

select * from emp where rownum<6

Then we can get the next 5 records by the following sql:

select * from emp where rownum<6 MINUS select * from emp where rownum<11

and so on...

hello your answer is correct but the sequence is wrong

To get first five records

select aud_trn_issue_header.* rownum from aud_trn_issue_header where rownum < 6

To get the next five records

select aud_trn_issue_header.* rownum from aud_trn_issue_header where rownum < 11 minus
select aud_trn_issue_header.* rownum from aud_trn_issue_header where rownum<6

and so on..............

bye

Hello

Please post correct queries after checking.

select * from

(select rownum rowpos emp.* from emp) inline_emp

where inline_emp.rowpos between 5 and 10

This should work for any rownum range......

~Al Di Meola

select A.R A.ename from (select rownum R ename from emp)A where A.r between &start and &end
/