select * from table where empno > 100 or ( select * from table where em

I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP!

Question Posted / venkat

17 Answers
27039 Views
KNIT, Tech Mahindra, I also Faced
E-Mail Answers

Answer Posted / venkat

select * from table where empno > 100 or ( select * from
table where empno < 200)

Some many ways to write a query for this, this is one way...

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

List out the three types of page locks that can be held.

1136

What is the physical storage length of the data types date, time, and timestamp?

1080

How to check last update on table in db2?

1039

How to create db2 table in mainframe?

1136

What is dbrm? When it will be created?

1010

What is a db2 table?

990

How do we specify index to include or not during bind process.

2107

Explain in detail about buffer manager and its functionalities?

1052

What is netezza database?

1001

Are views updateable?

1134

what is the responsibility of the construction superintendent

2132

What are the contents of dclgen?

1089

What is check constraint in db2?

1062

What is bufferpool in db2?

1026

What are host variables in db2?

1028