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
- 10537 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 are the 2 sqlcodes that are returned?
Where can you declare a cursor in a cobol-db2 program?
How do I optimize a query in db2?
Which isolation level provides highest data integrity?
Can we insert update delete in view?
What is the difference between drop table and delete table?
What is host variable in db2 cobol?
What is null indicator in cobol db2?
is it compulsory commitment control in journal?
What is a db2 tablespace?
i want to maintain uniqueness on pdf without make lf??????????
What are the different types of base tables?
What is runstats utility in db2?
What is dbrm library?
What is a db2 cursor?
