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
- 24399 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
List out the buffer pools in db2
How do I connect my db2 database to ibm?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What's The Percentage Free Space ?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is difference between isnull and coalesce?
Define predicate?
Outputs of explain are with matchcols = 0. What does this signify?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Name the lockable units in DB2?
What are the contents of a dclmgen?
What is db2 optimizer?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What does db2 blu stand for?
How do I delete a table in database?
