select t1.string, t1.num from (select string, num, rownum rn from test_table) t1 where t1.rn between 5 and 7;