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 / divya,roshini,tiny
use scrollable cursor for fetching the 10th row
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the difference between db2 and oracle?
What is plan in cobol db2?
How can record locking be achieved in those DB2 versions which do not support it?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Which component is responsible for processing sql statements and selecting access paths?
How do you pull up a query which was previously saved in qmf?
Can you tell me how can you find out the # of rows updated after an update statement?
Explain about mirror activator disk mirroring?
What is db2 optimizer?
How do we specify index to include or not during bind process.
What are catalog tables in db2?
What are foreign keys in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Can we delete records from view?
How to view db2 table structure?