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
- 27049 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / prasenjit
With reference to Mr.Om......
In the question itself i had mentioned that you are not
supposed to use any keys....so that negates your query
where u have used empno as a key!
Arent there any solution for this?
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to find the number of rows in db2 tables?
define clustering index.
How will you return the number of records in table?
What is null value in db2?
What is the physical storage length of date data type?
What is the default page size of buffer pools?
If I have a view which is a join of two or more tables, can this view be updateable?
What is the difference between bind and rebind in db2?
What is clone table?
Before you give the explain statement, what are the prerogatives?
What is the physical storage length of the data types date, time, and timestamp?
What is dbrm in db2 database?
What is the maximum No of rows per page?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
