select a1.* (select a.*, rownum rn from (select * from table1 where field1 = ? order by field2) a where rownum > ???) a1 where a1.rn <= ???
