delete from table_name where address = '456' and '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 / mithlesh

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

Answer Posted / mithlesh

delete from table_name
where address = '456' and '678'.

Is This Answer Correct ?

10 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can record locking be achieved in those DB2 versions which do not support it?

1130

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

1539

What is the difference between cursor and select statement?

1152

What is ibm db2 client?

1007

What are the 2 sqlcodes that are returned?

1235

Which are the db2 tools to protect integrity of the database?

1167

What is load utility in db2?

1229

What is db2? Explain.

1111

Is it possible using max on a char column?

1192

How to check table size in db2 sap?

1096

What is meant by union and union all?

1054

What is the meaning concurrency in the db2 database?

1169

How do I create a view in db2?

1075

How do we specify index to include or not during bind process.

2177

What is explain in db2?

1079