select column1 
  from (
        select column1, rownum
          from table 1
       )
 where rownum > ? and rownum < ?