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
How connect db2 database to datastage?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What are union and union all?
What is collection in db2 bind?
How does coalesce work?
What is lock escalation in db2?
What is a db2 collection?
Explain about rct.
What is the physical storage length of date data type?
What is null value in db2?
What is drop table?
What is a db2 cursor?
What is a storage group (stogroup)?
What is the max length of sqlca?
List out the data types available.