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 the use of <> sql?

738

How do I trace sql profiler?

708

What is having clause in sql?

716

What is the size of partition table?

742

What are the advantages of pl sql?

835

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

748

discuss about myisam index statistics collection. : Sql dba

697

What is the difference between view and stored procedure?

693

What are sql indexes?

740

Explain the significance of the & and && operators in pl sql.

748

What is a heap in sql?

723

Is null operator in sql?

795

What is difference between table and view?

708

What is a crud api?

686

how to get a list of indexes of an existing table? : Sql dba

713