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 / nadeem
Use any one column name and its value of the 10th row to
fetch the 10th..for eg
select * from Table where deptno = 0010(any column name and
its value of 10 row)
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
List some fields from sqlca?
What is the maximum length of sqlca?
What is copy pending and check pending in db2?
What is isolation level in db2?
How would the varchar column remarks defined?
How is deadlock resolved?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Name the lockable units in DB2?
What is bind in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is host variable?
What is a db2 table?
What is blu acceleration in db2?
Which components manage deadlocks in db2?
Highlight all the advantages that are attached to a package.