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 / nayana

Answer Posted / nayana

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which one is better subquery or joins?

1039

What is schema in sql?

927

What is scope and visibility in PL/SQL?

1178

Does sql profiler affect performance?

975

Do foreign keys improve performance?

1006

What are the different type of joins in sql?

934

what is a composite key ? : Sql dba

1032

What makes a good primary key?

1014

What is difference between procedure and trigger?

959

What is sql comments?

1059

what is the difference between blob and text? : Sql dba

1002

what are the differences between char and nchar? : Sql dba

1096

How do I view a procedure in sql?

953

explain the advantages and disadvantages of stored procedure? : Sql dba

990

What is gpt format?

927