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

How to update more then one record using update?

Question Posted / guna

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

Please Help Members By Posting Answers For Below Questions

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1272

what is the responsibility of the construction superintendent

2140

What is a bind in db2?

1037

Is db2 a mainframe database?

996

What is the maximum size of a char data type in db2?

1008

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1041

What is plan in cobol db2?

1130

what is utility for parm lib

2367

What are iseries servers?

1071

Mention the location where the output received from explain statement is stored.

1120

What is a db2 cursor?

1043

Explain in brief how does db2 determine what lock-size to use?

1034

What is the syntax for creating a table in the db2 database?

1102

What is netezza database?

1017

How to retrieve rows from a db2 table in embedded sql?

1384