ROWNUM Problem

[Carlos Juan]

Hi,

I have an application that shows the data based on the search criteria, shows 10 records a time. I have a table with 1000+ 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

Any help is appreciated. Thanks

[stu derby]

Originally posted by Carlos Juan:
Hi,

I have an application that shows the data based on the search criteria, shows 10 records a time. I have a table with 1000+ 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

Any help is appreciated. Thanks

Right. The ROWNUM doesn't start increasing until a row is definitely in the final result.

What you waht is:

select column from
(select column, rownum r
 from table)
where r between ? and ?