i have a table like this :
Name ADDRESS
Toto 123 ...
Toto 456
ToTo 678
I would like to delete 2 last row...please tell me how to
delete its
Answer Posted / siri
DELETE FROM TABLE WHERE ADDRESS IN('456','678')
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain in brief how does db2 determine what lock-size to use?
What is the max length of sqlca?
Which component is used to execute the sql statements?
How to check last update on table in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Which is faster delete or truncate?
How do I delete a table in db2?
What are the full forms of spufi and dclgen and why are they used?
What is sqlca?
How can you classify the locks in db2?
What is a db2 schema?
What is a system catalog table in db2?
Which isolation level provides maximum concurrency?
What is buffer pool and list some of them?
Is the primary key a clustered index?