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
9068 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 does db2 sample database connect?

975

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4215

what is the sqlcode -501

12926

What is check constraint. Explain with example.

1047

How do you eliminate duplicate values in db2?

1110

How to find the number of rows in a db2 table?

1066

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

1312

What is db2 instance?

1019

What is the reason behind not using select * in embedded sql programs?

1047

How do I copy a table in db2?

954

Explain about mirror activator disk mirroring?

961

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?

9002

What are concurrency issues?

1032

Define data page.

1015

What is explain in db2?

961