select * from employees where rownum<102 minus(select * from employees

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

Question Posted / subhradeep

Answer Posted / subhradeep

select * from employees where rownum<102
minus(select * from employees where rownum<81)

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is crud stand for?

930

When is a declare statement required?

1078

Are subqueries better than joins?

916

what is transaction? : Sql dba

958

what is the difference between a local and a global temporary table? : Sql dba

1003

Can we use views in stored procedure?

967

How do I tune a sql query?

933

Are stored procedures compiled?

867

What is nvl?

1018

What is java sql drivermanager?

1019

What is procedure function?

981

What is the usage of distinct keyword?

1017

What is sql and its types?

1108

What is a natural join sql?

919

What is serial sql?

915