select * from(
                select rownum rnum, A.*  from table_name A
              )
              where rnum <100 and rnum>10;