Team,

I am struggling to get the data from the database page by page. I went thro the archives of this forum and i found this query to be very useful and similar to my requirement.

It works like charm for the first page ( i.e. 0-10) but for the next page it is not working as i expected.

There are 11 rows in the table. When i do a query for 0-10 it is working perfectly like the one below.

Here is the query
--------------------
select messageID, parentID, title, author, updatedTime
from
(select messageID, parentID, title, author, updatedTime
from
(select messageID, parentID, title, author, updatedTime
from ent_bulletin_messages
where sectionID=10
order by messageID, parentID)
where rownum < =11)
where rownum > 0

BUT WHEN I CHANGE THE PARAMETERS TO
rownum <=20
where rownum > 10

IT SAYS NO ROWS SELECTED.

I DONT KNOW HOW TO MAKE THAT HAPPEN.

Can anyone please please help me out.

Thanks a million
Seenu