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
27241 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

Can we insert update delete in view?

973

Which component is used to execute the sql statements?

1103

How can the duplicate values be eliminated from db2 select?

1106

Mention the location where the output received from explain statement is stored.

1129

What parameters are used to control the free space in DB2?

1059

What is host variable in db2 cobol?

1082

What is database alias db2?

1132

What is a buffer in memory?

1065

How can you classify the locks in db2?

1092

what are bind concepts in db2 cobol?

1097

How to find the maximum value in a column in the db2 database?

1084

What is syscat in db2?

1018

What is difference between isnull and coalesce?

1059

How many types of page locks can be held in db2?

1044

What does db2 blu stand for?

1170