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
27712 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 copy pending and check pending in db2?

1040

What is db2 connect?

1124

On which levels locks can be applied?

1200

How can you classify the locks in db2?

1130

How would you find out the total number of rows in a db2 table?

1094

How to check sequence on a table in db2?

1111

Who uses db2?

1111

What are iseries servers?

1127

What is access path in db2?

1042

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

1156

What are the 2 sqlcodes that are returned?

1232

What is view db2?

1130

What is with ur in db2?

1382

What are packages in db2?

1071

What is the physical storage length of time data type?

1175