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

What is dpf in db2?

1109

What is a buffer in memory?

1058

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1077

What is db2 command?

1035

Explain the benefits you can get from mainframe connect?

970

When the like statement is used?

1222

Define db2 and its databases?

1055

What is role in db2?

1107

B37 abend during spufi?

1455

What os does db2 run on?

980

What do you mean by storage group (stogroup)?

1041

What do you mean by cursor?

988

Is db2 relational database?

979

How do I connect my db2 database to ibm?

1050

What is meant by explain?

1133