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
- 22482 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 meant by union and union all?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is dbrm library?
Name the various locking levels available?
What is a collection in db2?
How to check sequence on a table in db2?
What is copy pending and check pending in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is table space in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is performance tuning db2?
Explain about rct.
Explain various types of locks in db2?
What is netezza database?
