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

Answer Posted / mithlesh

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

Is This Answer Correct ?

10 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How is deadlock resolved?

650

What is a plan and package in db2?

625

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

750

What db2 400?

677

List some fields from sqlca?

613

Why do we need reorg in db2?

564

How to connect to db2 database from windows command line?

562

What is package in db2 mainframe?

559

What is the syntax for FETCH in DB2 ?

675

What is a system catalog table in db2?

588

What is dclgen in db2?

678

How to check table size in db2 sap?

581

What is universal database?

617

What is the use of value function?

629

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1578