posted 24 years ago
Hi,
I tried using a similar select statement in Oracle 8i, but it does not work.
Example: SELECT EMPNAME FROM EMPLOYESS WHERE ROWNUM < 11;<br /> Gives first 10 rows.<br /> SELECT EMPNAME FROM EMPLOYESS WHERE ROWNUM > 11 AND ROWNUM < 21;
no rows selected.
This is because rownum value is a post-query value, ie, our query should first reach that particular row, only then can you access rows with ROWNUM.
Correct me if I'm wrong. I could not use the second select statement in my query.
Thanks.