display records from 5 to 9 using rowid or rownum

Question Posted / sunil

Answers were Sorted based on User's Feedback

display records from 5 to 9 using rowid or rownum..

Answer / vinay shankar

select * from emp
where rownum <=9
minus
select * from emp
where rownum <5

Is This Answer Correct ?

31 Yes

6 No

display records from 5 to 9 using rowid or rownum..

Answer / chiru

select * from (select rownum r ,a.* from emp a ) where r between 5 and 9

Is This Answer Correct ?

7 Yes

0 No

display records from 5 to 9 using rowid or rownum..

Answer / ramaraju

select
ename
from
emp
order by ename
offset 4 rows
fetch next 5 rows only;

try this answer oracle 12c introduced offset fetch rows.

Is This Answer Correct ?

1 Yes

0 No

display records from 5 to 9 using rowid or rownum..

Answer / hari

select * from (select rownum rm,id from emp where rownum<=9) where rn >=5)

Is This Answer Correct ?

4 Yes

5 No

display records from 5 to 9 using rowid or rownum..

Answer / satya

select empno,ename,sal from emp
group by rownum,empno,ename,sal
having rownum between 5 and 9;

Is This Answer Correct ?

2 Yes

9 No