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

Which is faster count (*) or count 1?

1009

What are procedures used for?

969

how can we know the count/number of elements of an array? : Sql dba

1044

What is the difference between function and procedure in pl/sql?

1057

how to add a new column to an existing table in mysql? : Sql dba

1049

How do you remove duplicates without using distinct in sql?

963

What is indexing in sql and its types?

1058

Explain what is sql*plus?

1125

How can the performance of a trigger be improved?

1022

What is %type in sql?

948

Which data dictionary views have the information on the triggers that are available in the database?

1226

What is t sql in sql server?

1055

What is field delimiter?

1035

How do I install sql?

974

What is pl sql block in dbms?

991