write the sql query to display 5th and 10th row in a table?

Question Posted / kishore

Answers were Sorted based on User's Feedback

write the sql query to display 5th and 10th row in a table?..

Answer / lakshmi reddy

select * from(select emp.*,rownum r from emp) where r=5 or r=10

Is This Answer Correct ?

8 Yes

1 No

write the sql query to display 5th and 10th row in a table?..

Answer / kart

select * from (select rownum as rn,aone.* from aone)
where rn in(5,10);

Is This Answer Correct ?

6 Yes

0 No

write the sql query to display 5th and 10th row in a table?..

Answer / gautam ramteke

select *
from(select rt.*,rownum r from (select * from gpr_employee
order by hire_date)rt)
where r in (5,8);

Is This Answer Correct ?

2 Yes

0 No

write the sql query to display 5th and 10th row in a table?..

Answer / gopal

By using rank or dense_rankl()

Is This Answer Correct ?

1 Yes

0 No

write the sql query to display 5th and 10th row in a table?..

Answer / harish

select * from emp where rownum<=&n;
if u give 5 insted of 'n' we get 5th record...

Is This Answer Correct ?

1 Yes

1 No