select Ename, empno, rn from (select rownum rn, ename, empno from emp) w

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

Question Posted / ajit

Answer Posted / ajit

select Ename, empno, rn
from (select rownum rn, ename, empno
from emp)
where rn between &gno and &gno

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the non-clustered index in sql?

1064

What is the difference between an inner join and an outer join?

1028

How many parts of a pl sql block are optional?

1137

What does plv msg allows you to do?

1144

What is the source code of a program?

1074

What is duration in sql profiler trace?

1085

What is difference between sql and oracle?

1134

What pl/sql package consists of?

1089

What are inner and outer joins examples of both?

966

What is a stored procedure in sql with example?

1136

What is sqlcontext?

1088

What are different methods to trace the pl/sql code?

1123

What is type and rowtype in pl sql?

1020

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1075

what is the difference between nested subquery and correlated subquery?

1058