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
- 27040 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
How to find the number of rows in db2 tables?
How do I connect my db2 database to ibm?
How to resolve deadlock issue
How is deadlock resolved?
Which component is used to execute the sql statements?
What is the use of predicate?
what are bind concepts in db2 cobol?
What is declare cursor?
B37 abend during spufi?
What is a buffer in memory?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How can the duplicate values be eliminated from db2 select?
How is a typical db2 batch pgm executed?
What are the different types of base tables?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
