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
- 26449 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 meant by explain?
What types of tables are there in the db2 database?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is db2 bind?
What does db2 blu stand for?
What are db2 objects?
What is a db2 table?
How to rename a table in DB2 ?
Define buffer pool.
What db2 400?
How to take backup of table in db2?
Which component is responsible for processing sql statements and selecting access paths?
What is the role of the data page in the db2 database?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Why select is not preferred in embedded sql programs?
