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
- 27217 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
How do I copy a table in db2?
What is the role of data manager in the db2 database?
Mention the definition of cobol in varchar field.
Give a brief description of db2 isolation levels?
Explain correlated sub-queries.
What is a bind in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Explain about rct in db2?
Why do we use cursor?
Which isolation level provides highest data integrity?
What is dbrm in db2 database?
What is the maximum number of columns in a db2 table?
How can the duplicate values be eliminated from db2 select?
What is runstats and reorg in db2?
What happens in bind step in a db2 program?
