Previous Topic: Example 1Next Topic: WHILE Statement

SQL Statements › UPDATE › Searched UPDATE › Example 2

Example 2

Increase the job code by 10 members in Department D11.

      UPDATE CA.TEMPL
      SET JOBCODE = JOBCODE + 10
      WHERE WORKDEPT = 'D11'