select * from (select a.*, row_number() over (order by empno) rn from emp a

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

Question Posted / jayanth

Answer Posted / jayanth

select * from (select a.*, row_number() over (order by empno) rn from emp a) where rn between 100 and 120;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we join two tables without common column?

1063

What is crud diagram?

996

Does truncate release storage space?

1148

What is assignment operator in pl sql?

1089

What is difference between hql and sql?

1168

What are triggers in sql?

1061

Is it possible for a table to have more than one foreign key?

1084

how can we know the number of days between two given dates using mysql? : Sql dba

1091

Explain the difference between sql and mysql.

1117

What is the difference between the implicit and explicit cursors?

1114

How do you declare a variable in pl sql?

1073

What are the different sql languages?

1096

Is sqlite free?

1024

What is the difference between clustered and non-clustered index in sql?

1069

what is the difference difference between procedure and packages

10554