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

What is the use of db2?

1055

What is the use of runstats in db2?

1108

What is db2 and what is the use of db2 optimizer?

1064

Can you use max on a char column?

1097

List down the data types in the db2 database.

1123

Is the primary key a clustered index?

1149

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3581

What are catalog tables in db2?

1048

What is the difference between oracle and db2?

1107

What is db2 instance?

1094

What is precompiler in db2?

1017

What is difference between rollback and commit?

1157

What is a trigger in the db2 database?

1080

Mention the definition of cobol in varchar field.

1250

Mention data types used in db2 ?

1156