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
- 22483 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 to take backup of table in db2?
What is alias in db2?
How do I import data from excel to db2?
How can you quickly find out the # of rows updated after an update statement?
What is precompiler in db2?
Explain the contents that are a part of dclgen.
What is meant by explain?
what are bind concepts in db2 cobol?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What are the various data types available in db2?
i want to maintain uniqueness on pdf without make lf??????????
What do you mean by storage group (stogroup)?
What are the various isolation levels possible?
What is a collection in db2?
What is the difference between drop table and delete table?
