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

Can we delete column in sql?

1026

what's the difference between a primary key and a unique key? : Sql dba

973

What is normalization? How many normalization forms are there?

1013

How to use boolean type in select statement?

997

Where the sql database files are stored?

958

Show the two pl/sql cursor exceptions.

1110

Why primary key is required?

939

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1094

what is primary key? : Sql dba

956

how many columns can be used for creating index? : Sql dba

899

What is data profiling in sql?

1021

What are local and global variables and their differences?

1048

Is null operator in sql?

980

What is the difference between python and sql?

940

What is an exception in pl/sql?

1009