...
UPDATE COMPANY SET ADDRESS = 'California' WHERE ID = 2;
SELECT * FROM COMPANY;
UPDATE COMPANY SET SALARY = SALARY + 3000 WHERE SALARY <=30000;
SELECT * FROM COMPANY;
Tallennus
...
...
UPDATE COMPANY SET ADDRESS = 'California' WHERE ID = 2;
SELECT * FROM COMPANY;
UPDATE COMPANY SET SALARY = SALARY + 3000 WHERE SALARY <=30000;
SELECT * FROM COMPANY;
...