How to update more then one record using update?
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
Explain packages.
Define db2 and its databases?
What is a db2 table?
What is the usage of open cursor command?
How would you find out the total number of rows in a db2 table?
What parameters are used to control the free space in DB2?
What types of tables are there in the db2 database?
B37 abend during spufi?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How can we retrieve the total number of records in RPG & CLLE?
what is utility for parm lib
What is a buffer in memory?
What is a page in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the syntax for FETCH in DB2 ?