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
- 10928 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
what is diffrence b/w file-aid tool and file-aid utility???
What is meant by explain?
Explain the benefits you can get from mainframe connect?
What is the difference between nvl and coalesce?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Define declaration generator (dclgen).
What is reorg?
What are the contents of dclgen?
Mention some fields that are a part of sqlca.
How do you pull up a query which was previously saved in qmf?
Explain the contention situations caused by locks?
What is the use of predicate?
Which isolation level provides highest data integrity?
Mention data types used in db2 ?
What is db2 and what is the use of db2 optimizer?
