SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ROWNUM Problem

435184Jul 22 2006 — edited Jul 22 2006

Hi,

I have table with 500+ records. When I run the following select it returns me the 1st 10

SELECT column FROM table WHERE ROWNUM BETWEEN 1 AND 10

Now if I run the following it does not return me any data

SELECT column FROM table WHERE ROWNUM BETWEEN 11 AND 20

I am building an app. with pagination i.e. want to show 10 records a time but the query above is not returning anything. What else I can use. Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 19 2006

Added on Jul 22 2006

4 comments

871 views