How to update multiple columns in single update statement in DB2

Question

I need to update multiple columns of a table in DB2 with a single update statement.

Any kind of help will be appreciated.

Answer 1

The update statement in all the versions of SQL will be like:

update table
    set col1 = expr1,
        col2 = expr2,
        . . .
        coln = exprn
    where some condition

Therefore, the answer is that you separate the assignments using commas and don't repeat the set statement.

Want to know more about SQL? Join this SQL Course by Intellipaat.