We can make use of Relative record number that is Select * from Table A

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 / sangeeta david

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

Answer Posted / sangeeta david

We can make use of Relative record number that is

Select * from Table A where RRN(A) between 100 and 200

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define db2.

1064

What is the role of schema in the db2 database?

1181

How is the value function used?

1080

What is the use of db2?

1005

Can we update view in db2?

945

What language is db2 written in?

980

How do I add a column in db2?

997

When the like statement is used?

1156

What is a collection in db2?

983

What is db2 instance?

1016

What are union and union all?

920

How to compare data between two tables in db2?

1031

What is a db2 table?

954

What is the difference between cursor stability and repeatable read isolation levels?

1114

What is bufferpool in db2?

984