select * from( select rownum rn,t.* from table_name t where rownum<=N) where rn=N; Example: select * from( select rownum rn,t.* from employee t where rownum<=101) where rn=100; Or select * from table_name a where rownum <= N minus select * from table_name where rownum < N; Example: select * from employee a where rownum <= N minus select * from employee where rownum < N; |