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
27758 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 buffer pools in db2

1131

What is the picture clause of null indicator variable?

1186

What is the use of db2?

1118

What is reorg and runstats in db2?

1263

What is rebind in db2?

1121

What is db2? Explain.

1113

Name the lockable units in DB2?

1190

How is deadlock resolved?

1208

What is database reorganization?

1185

What are the rules for db2 programming?

1156

What action db2 takes when a program aborts in the middle of a transaction?

1199

What is buffer pool and list some of them?

1099

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1295

How to take backup of table in db2?

1129

How to restart a DB2 program?

1961