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

21 Answers
28324 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / subhradeep

select * from employees where rownum<102
minus(select * from employees where rownum<81)

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many times can we commit in a loop?

1067

What are the built in functions of sql?

1096

Enlist the advantages of sql.

1054

How to Declare Fixed Length String Value In PL SQL

1208

What is sql mysql pl sql oracle?

1129

Is null operator in sql?

1094

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4061

How do I view a sql trace file?

1064

What does select top 1 do in sql?

1142

What is use of package in pl sql?

1071

How to avoid duplicate records in a query?

1055

Why do we use procedures in pl sql?

1077

What are conditional predicates?

1128

Does truncate release storage space?

1137

what is offset-fetch filter in tsql? : Transact sql

1000