Hi,

I tried the query and it works fine, but when I want to display a range of values say from 10 to 20 it doesn't work, and I don't understand why!

select rownum,viewid from
(
Select viewid
from all_stats
order by viewid
)
where rownum between 10 and 20

down't return any rows

and


select rownum,viewid from
(
Select viewid
from all_stats
order by viewid
)
where rownum < 20

returns 19 rows

so how to get from 10 to 20?