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 are the different parts of a package?

1155

What is varchar data type in sql?

1140

Define the select into statement.

1112

What is scope and visibility in PL/SQL?

1291

explain the delete statements in sql

1137

What is a call statement? Explain with an example.

1071

What is before trigger?

1051

Explain scalar functions in sql?

1106

What are reports usually used for?

1085

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

1047

Is inner join faster than left join?

1252

What are the constraints available in sql?

1088

What is a trigger in sql?

1235

What is the difference between syntax error and runtime error?

1185

What is the difference between a subquery and a join?

1173