Interested to Buy Any Domain ? << Click Here >> for more details...
In my table having 100 Rec. How can I delete the 7th row??
(we don't know what is data inside the table)
- 9 Answers
- 15521 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / tim v
Are we talking the 7th row as sorted by key or 7th physical row? Since the rows aren't normally physically stored in order, I'd have to go with the latter.
Everyone seems to assume there is a PK on the table, but yet we don't know anything about the data... Again, this points to 7th physical row.
I'd go with the delete where RID(table) = 7 option since this assumes the 7th row inserted based on position and not value.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is dbrm library?
What does reorg do in db2?
Explain the contention situations caused by locks?
Which isolation level provides highest data integrity?
What is the function of logging in the db2 database?
Where do you specify them?
what is the sqlcode -501
Which component is responsible for processing sql statements and selecting access paths?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is commit in db2?
How do you stop a db2 database in linux?
How do I delete a table in database?
What is the maximum size of a char data type in db2?
Why do we bind in db2?
What is the maximum No of rows per page?
