rownumとbetween

stackoverflow.com

www.shift-the-oracle.com

core-dumped.blog.so-net.ne.jp

rownum betweenするときは、rownumを別名で入れておかないといけないっぽい。

select * from (select TEST.*,rownum as rownum1 from TEST) where rownum1 between 11 and 20;