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
- 15746 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / mdv
DELETE FROM TABLE_NAME
WHERE RID(TABLE_NAME) = 7 ;
Works DB2 (V9 Onwards)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can you count the number of rows from a table tab?
What is db2 look?
How do you eliminate duplicate values in db2?
What is phantom read in db2?
What is the max length of sqlca?
How can you quickly find out the # of rows updated after an update statement?
What is the role of the data page in the db2 database?
What is isolation level in db2?
What is a bind in db2?
What is database manager in db2?
What are union and union all?
What type of database is db2?
What does reorg do in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is coalesce in db2?
