Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 10785 Views
- I also Faced
- E-Mail Answers
Answer Posted / andyb
Why?
How do you know the one you want is still the 10th row ?
Other updates may have taken place.
If you know the key for the record you want then use that
Otherrwise unless the table has a sequential numeric key
then I think you have to go through the rows.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to compare data between two tables in db2?
What is the use of dclgen in db2?
What is universal database?
What is the physical storage length of the data types date, time, and timestamp?
How to find the number of rows in a db2 table?
What is runstats utility in db2?
What is a dbrm in db2?
What is catalog database in db2?
What is the role of union all and union
What is null indicator in cobol db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
what is diffrence b/w file-aid tool and file-aid utility???
How does coalesce work?
What is the use of predicate?
When reorg is used?
