Which UPDATE statement correctly increases every employee's salary by 10%?
-
A
UPDATE employees SET salary = salary * 1.10;
-
B
UPDATE employees SET salary + salary * 0.10;
-
C
UPDATE employees MODIFY salary = salary * 1.10;
-
D
ALTER employees SET salary = salary * 1.10;