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
- 27022 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 clustering index in the db2 database?
What is the maximum size of a char data type in db2?
How does cobol compile db2 program?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What are union and union all?
What is the use of commit in db2?
What are db2 tables?
What is db2 plan table?
How to check table size in db2 sap?
How do you pull up a query which was previously saved in qmf?
What is db2 instance?
What r the comman abends in db2, jcl and cobol???????
Explain db2.
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What are the various isolation levels possible?
