select * from(select rownum id,table1.* from ( select * from table1 order by CreateDate ) where rownum <= 20000) where id > 10000;