DELETE FROM TABLE WHERE ADDRESS IN('456','678')

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

Question Posted / siri

5 Answers
9308 Views
EDS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Why db2 is called db2?

1044

How do I delete a table in database?

1023

Is db2 a programming language?

1051

What is the latest version of ibm db2?

1269

What is schema in db2?

1022

What is performance tuning db2?

1064

What is difference between isnull and coalesce?

1056

What is sqlca?

1079

What is ibm db2 connect?

1002

What is meant by union and union all?

1012

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9216

What is a collection in db2?

1036

What are the contents of a dclmgen?

1131

B37 abend during spufi?

1455

What is access path in db2?

986