n records at a time

[PSoni]

If you want select particular column
then it is very easy

see my example

select rownum , dname from dept
having rownum between 1 and 5 group by rownum, dname;

abvoe will select from rownumber 1 to 5

select rownum , dname from dept
having rownum between 6 and 10 group by rownum, dname
above will select from rowno 6 to 10


thanks
Pitamber Soni