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


Oracle LazyDBA home page