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 ttitle and btitle?

1046

What are the different schemas objects that can be created using pl/sql?

999

Why we use join in sql?

944

Difference between table function and pipelined function?

999

Is sql procedural language?

952

What are the limitations of sql express?

1042

Is sql easier than java?

988

What is the use of desc in sql?

956

Explain the difference between sql and mysql.

1039

What is the difference between delete and truncate commands?

1018

Why is sharding used?

978

Explain 3 basic parts of a trigger.

1296

Why is sql better than hql?

970

How is debugging done?

958

How do you drop a trigger?

967