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

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

Question Posted / swapna

Answer Posted / swapna

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

Is This Answer Correct ?

11 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How to create your own reports in sql developer?

1030

State few characteristics of pl/sql?

977

Is not equal in sql?

1019

How does left join work in sql?

1012

Will truncate release space?

959

Is pl sql better than sql?

1044

What is sql profiler in oracle?

1101

Why use truncate instead of delete?

1022

What is offset in sql query?

1126

what is myisam? : Sql dba

1091

how can you create an empty table from an existing table? : Sql dba

1158

Which table is left in left join?

1023

how to drop an existing view in mysql? : Sql dba

1068

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1812

Explain what is dbms?

1071