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
- 26427 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
How would you find out the total number of rows in a db2 table?
What is a db2 collection?
How to run db2 command in windows?
Why cursor is used in db2?
Is db2 relational database?
How can you classify the locks in db2?
What is dbrm library?
What is the difference between using bind () and rebind () methods of naming class?
What do you mean by storage group (stogroup)?
How to create backup table in db2?
What type of database is db2?
What is the difference between bind and rebind in db2?
What are the various isolation levels possible?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is db2 catalog database?
