Interested to Buy Any Domain ? << Click Here >> for more details...
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!
- 17 Answers
- 27726 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
What is the use of predicate?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What are the prerogatives?
What do you mean by cursor?
What db2 400?
What is image copy in db2?
What is copy pending and check pending in db2?
Comment whether the cursor is closed during commit or not.
What is the use of runstats in db2?
How does a cursor work?
What action db2 takes when a program aborts in the middle of a transaction?
How many databases can be created inside an instance in db2 ?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is a plan and package in db2?
How to find schema of a table in db2?
