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

Does sql*plus have a pl/sql engine?

1051

What is nested table in pl sql?

1051

What is number function in sql?

943

What is blind sql injection?

1043

what is 'mysqlimport'? : Sql dba

1018

What are the different types of functions in sql?

1035

How to Declare Fixed Length String Value In PL SQL

1135

What does select top 1 do in sql?

1077

How to write pl sql program in mysql command prompt?

1068

What is the difference between subquery and correlated query?

1042

How to display Row Number with Records in Oracle SQL Plus?

1025

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1216

When should I use nosql database?

985

What are predefined functions in sql?

1023

What is auto increment?

972