-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|