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

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1067

How much does sql certification cost?

1045

what are properties of a transaction? : Sql dba

1054

how to create a new table by selecting rows from another table in mysql? : Sql dba

1037

What is Collation Sensitivity ? What are the various type ?

927

What is user in sql?

988

Why is pl sql used?

953

what is a composite key ? : Sql dba

1008

What does sql stand for?

961

what is csv? : Sql dba

959

What is linq to sql?

1104

How do I create a memory optimized filegroup?

919

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1059

What is a scalar value in sql?

1032

What is a sql select statement?

1013