select * from emp where rownum<121 minus(select * from emp where rownum

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

Question Posted / laks

Answer Posted / laks

select * from emp where rownum<121
minus(select * from emp where rownum<101)

Is This Answer Correct ?

34 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Which table is left in left join?

952

How many row comparison operators are used while working with a subquery?

974

What are %type and %rowtype for?

1012

What is a unique key and primary key and foreign key?

918

Explian rowid, rownum?

956

How does left join work in sql?

939

What is the difference between alter trigger and drop trigger statements?

1042

What is difference between table and view?

975

What is an emotional trigger?

930

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

906

How many types of triggers exist in pl/sql?

1009

Can we commit inside a trigger?

942

How to return multiple rows from the stored procedure?

913

What is difference sql and mysql?

939

What is a scalar value in sql?

1011