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
- 27238 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
What is phantom read in db2?
What is the difference between plan and package in db2?
What is db2 stogroup?
What is data manager?
What is the purpose of rollback and commit?
What is the role of union all and union
How to find primary key of a table in db2?
What is sqlca?
What is the difference between nvl and coalesce?
What is the physical storage length of timestamp data type?
What is iseries database?
What is access path in db2?
How do I delete a table in database?
How do we specify index to include or not during bind process.
List some fields from sqlca?
