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
- 10701 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
Who uses db2?
define clustering index.
What is db2?
can all users have the privilage to use the sql statement select * (dml)?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is consistency token in db2?
What is a db2 table?
What is the use of reorg in db2?
What is the difference between drop table and delete table?
What is the default page size of buffer pools?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How to execute stored procedures?
What is difference between alias and synonym in db2?
What is deadlock in db2?
What is the maximum size of varchar data type in db2?
