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

What will you get by the cursor attribute sql%found?

1009

Is sql an operating system?

1075

what is a database transaction? : Sql dba

1258

How to prepare for oracle pl sql certification?

1109

What is pl sql block structure?

1095

What is the execution plan in sql?

1071

What is synchronized subquery?

1222

how to increment dates by 1 in mysql? : Sql dba

1034

How show all rows in sql?

1060

What is difference between sql and oracle?

1192

What are the different types of dbms?

1067

How to call shell script from pl sql procedure?

1359

what are the features and advantages of object-oriented programming? : Sql dba

1075

What are the two types of periodical indexes?

988

Is sql pronounced sequel or sql?

1340