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
- 27030 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / m4io
scrollable cursors
------------------
DECLARE cursor_name sensitivity SCROLL CURSOR FOR
SELECT ... FROM ...
open cursor
FETCH ABSOLUTE 100 FROM cursor_name
do 100 times
FETCH NEXT FROM cursor_name
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is the use of with ur in db2?
What is the use of predicate?
Explain in detail about buffer manager and its functionalities?
List down the data types in the db2 database.
What is database manager in db2?
How do you stop a db2 database in linux?
Which isolation level provides highest data integrity?
How to resolve deadlock issue
How to connect to db2 database from windows command line?
Before you give the explain statement, what are the prerogatives?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What are foreign keys in db2?
What is the role of the data page in the db2 database?
What is database alias db2?
What is the reason behind not using select * in embedded sql programs?
