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
- 22522 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / prasenjit
Yes and no in both ways.
I know there is a Roid() Over() function DB2 release 7
onwards and that shld solve the problem.
But what if there was condition that you cant use these
functions.
Cant there be any query that can produce the req result.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the role of union all and union
What is the difference between plan and package in db2?
Is db2 free?
What is a bind in db2?
What are types of indexes?
What is dpf in db2?
How does coalesce work?
What is consistency token in db2?
What is a buffer in memory?
What is multi row fetch in db2?
What does sqlcabc has?
What is an instance database?
Why select is not preferred in embedded sql programs?
What os does db2 run on?
What is dbrm?
