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
- 27767 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
When the like statement is used?
What are the various isolation levels possible?
How to rename a table in DB2 ?
What are union and union all?
How do I add a column to a table in db2?
What is the information associated with sysibm.syslinks table?
What is the difference between cursor stability and repeatable read isolation levels?
What is db2 plan table?
What does db2 stand for?
What is the advantage in De-normalizing tables in DB2?
What language is db2 written in?
What is release/acquire in bind?
What is dbrm?
What is database manager in db2?
What is the connection string to connect to the DB2 Database ?
