mr. Prasenjit .. when you are going to select 100 record then you select

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 / om yadav

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

Answer Posted / om yadav

mr. Prasenjit ..
when you are going to select 100 record then you select
which column base you want the record taht base you mession
on condition.
than
if any other way please tell me.........

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is dclgen in db2?

1082

List out the data types available.

1081

What is difference between rollback and commit?

1092

What is db2 plan table?

992

How does cobol compile db2 program?

1005

How do I copy a table in db2?

950

How is the value function used?

1080

Is db2 free?

1035

What is the meaning concurrency in the db2 database?

1056

How do you pull up a query which was previously saved in qmf?

1099

How do I import data from excel to db2?

1011

What is the difference between drop table and delete table?

1117

What is the difference between dbm cfg and db cfg file in db2 ?

1477

Comment whether the cursor is closed during commit or not.

1040

What is role in db2?

1040