I want to fetch the 10th row of a table which has been
changed.How can I do it without going thru all the rows.
Answer Posted / m4io
DECLARE cursor_name sensitivity SCROLL CURSOR FOR
SELECT ... FROM ...
FETCH ABSOLUTE 10 FROM cursor_name
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain what are the various isolation levels possible?
What is meant by union and union all?
What are the contents of dclgen?
What kind of database is db2?
is it compulsory commitment control in journal?
What is innodb buffer pool?
Explain in brief how does db2 determine what lock-size to use?
What is isolation level in db2?
How do you select a row using indexes in db2?
Explain the benefits you can get from mainframe connect?
What is the use of db2?
What is precompiler in db2?
What are the different types of base tables?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Define declaration generator (dclgen).