Rownum is a value that is set only by the rows returned. Its kind of hard to predict what will be returned if you do anything other than a < condition on rownum. Your solution is to not use rownum the way you are using it.

-----Original Message-----
From: genegurevich
[mailto:oracledba-ezmlmshield-x97708131.[Email address protected]
Sent: Wednesday, May 04, 2005 4:07 PM
To: LazyDBA Discussion
Subject: can I get a range of rows using rownum






hi all:

I have been able to execute this:

select * from TABLE1 where rownum < 100 with no problem

but when I try to do where rownum > 10 and rownum < 100, I am getting odd
results...

Here is my table:
SQL> select * from test1;

F1
----------
1
2
3


4 rows selected.


Here is the query:

SQL> select * from test1 where rownum > 1 and rownum < 4
2 ;

no rows selected

Why do I get no rows here? Any thoughts?

thank you

Gene Gurevich



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page