In my table having 100 Rec. How can I delete the 7th row??
(we don't know what is data inside the table)
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
What are the full forms of spufi and dclgen and why are they used?
Who uses db2?
What is the use of reorg in db2?
What's The Percentage Free Space ?
Why cursor is used in db2?
Is db2 relational database?
What is the use of predicate?
How to create backup table in db2?
What are catalog tables in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How does db2 sample database connect?
What is reorg and runstats in db2?
How to find schema of a table in db2?
Can you tell me how can you find out the # of rows updated after an update statement?