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

What is pl sql block structure?

1018

What is a record in a database?

1043

How do I find duplicates in a single column in sql?

1003

what does the t-sql command ident_incr does? : Transact sql

1054

How to read xml file in oracle pl sql?

899

What are the two different parts of the pl/sql packages?

1071

what is union? : Sql dba

1008

How to order siblings in oracle hierarchy queries?

1025

What does select top 1 do in sql?

1077

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

1066

what are different types of keys in sql?

1129

What are the differences between in and exists clause?

1091

how to drop an existing table in mysql? : Sql dba

1027

Why do we need cursor in pl sql?

1121

Can we connect to postgresql using sql developer?

985