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

What is a db2 package?

985

What is the picture clause of null indicator variable?

1080

Explain what are the various isolation levels possible?

986

What are the 2 sqlcodes that are returned?

1125

What is the physical storage length of date data type?

1183

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1053

Define db2 and its databases?

995

How to take backup of table in db2?

1020

Define buffer pool.

996

What is dpf in db2?

1047

Explain about rct.

1024

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2864

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1101

What is sqlca?

996

What is an instance database?

1002