select t2.* from (select t1.*,rownum rn from (select * from mytest) t1 where rownum<=860010) t2 where rn>=860000;