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
What is bufferpool in db2?
How to resolve deadlock issue
How to run db2 command in windows?
What types of tables are there in the db2 database?
What are the bind parameters ibm db2?
What is cloudant database?
Who uses db2?
What is the physical storage length of the data types date, time, and timestamp?
What is a system catalog table in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is bind and rebind in db2?
What is clone table?
What is the difference between cursor and select statement?
Is db2 relational database?
What is schema in db2?