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

21 Answers
26914 Views
IBM, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is asqueryable?

905

how to create a test table in your mysql server? : Sql dba

946

What is cascade in sql?

916

What is tuple in sql?

1008

What is the need of a partition key?

942

How many subqueries can be nested in a statement?

935

What is db journal file?

956

What are conditional predicates?

990

Does sap use sql?

933

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2451

What is use of term?

1008

What is plpgsql language?

980

Why is sharding used?

941

Can %notfound return null after a fetch?

1005

Mention what is the use of function "module procedure" in pl/sql?

1009