select rn, ename from (select rownum rn, ename from emp) where rn betwee

A table has 150 records. How do you retrieve 100th row to
120th row from that table ?

Question Posted / ajit nayak

Answer Posted / ajit nayak

select rn, ename
from (select rownum rn, ename
from emp)
where rn between 3 and 7;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is dense_rank?

879

What is group function in sql?

963

Can you join a table to itself?

1029

Can I learn sql in a week?

1004

What types of commands can be executed in sql*plus?

1048

What is difference between stored procedures and application procedures?

955

How to return multiple rows from the stored procedure?

912

Difference between global and parameter variables?

1905

Are sql database names case sensitive?

934

What sql database should I use?

1071

Why trigger is used in sql?

913

How to use transactions efficiently : transact sql

990

What is latest version of sql?

981

how are mysql timestamps seen to a user? : Sql dba

1047

What are pl/sql cursor exceptions?

1035