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

Are view updateable?

1095

What is the difference between spufi and qmf?

1208

What is the reason behind not using select * in embedded sql programs?

1174

What are union and union all?

1042

What are the rules for db2 programming?

1156

What does reorg do in db2?

1079

How to fetch the last row from the table in SQL (db2)?

1698

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

1218

What is the maximum size of a char data type in db2?

1056

What is the difference between using bind () and rebind () methods of naming class?

1466

How do you stop a db2 database in linux?

1062

What is dbrm library?

1120

Explain about mirror activator disk mirroring?

1065

How do I copy a table in db2?

1060

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11745