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


Please Help Members By Posting Answers For Below Questions

Explain what are the various isolation levels possible?

806


What is meant by union and union all?

784


What are the contents of dclgen?

851


What kind of database is db2?

783


is it compulsory commitment control in journal?

2225


What is innodb buffer pool?

760


Explain in brief how does db2 determine what lock-size to use?

787


What is isolation level in db2?

761


How do you select a row using indexes in db2?

853


Explain the benefits you can get from mainframe connect?

732


What is the use of db2?

799


What is precompiler in db2?

769


What are the different types of base tables?

771


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

977


Define declaration generator (dclgen).

880