Yurttas/PL/DBL/mysql/F/01/00/Company-B/q14.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1/*
 2REM
 3REM q14.sql
 4REM
 5REM Give all employees of 'First Bank Corporation' a 10 percent raise.
 6REM
 7*/
 8
 9\. set-db.sql
10
11UPDATE Works
12SET salary = salary * 1.1
13WHERE companyname = 'First Bank Corporation';