UPDATE table1 set columnname = (SELECT columnname from table2 where some

How to update more then one record using update?

Question Posted / guna

5 Answers
11470 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / guna

UPDATE table1 set columnname = (SELECT columnname from
table2 where some condition)

You can also use EXISTS instead of '=' for updating

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is node in db2?

1033

what is utility for parm lib

2348

Why do we need reorg in db2?

965

What do you mean by commit and rollback?

1025

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 ?...

4281

What is the use of predicate?

1024

How to find primary key of a table in db2?

1046

How do I copy a table in db2?

988

List some fields from sqlca?

1037

What is runstats db2?

1003

What is nvl in db2?

1081

Can we delete records from view?

952

What is the difference between bind and rebind in db2?

1425

Outputs of explain are with matchcols = 0. What does this signify?

1041

What is the difference between oracle and db2?

1072