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
- 15462 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
can all users have the privilage to use the sql statement select * (dml)?
How to resolve deadlock issue
Explain about dbrm.
What is scrollable cursor in db2?
What is the usage of open cursor command?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is a buffer in memory?
What is bind plan?
What are bind parameters in db2?
How do you find the maximum value in a column in db2?
What is an instance database?
What is database manager in db2?
How to view db2 table structure?
What is plan in cobol db2?
How to compare data between two tables in db2?
