I have to create a new column in my table called Raise that has a 20% raise from the values of the SAL column, here’s what I have so far:
SELECT ENAME,EMPNO, JOB, SAL from emp ALTER TABLE emp ADD Raise (INTEGER) ALTER TABLE emp Raise=SAL+SAL*0.20
Im not too sure what Im doing wrong here
Advertisement
Answer
Assuming that you are using Oracle (because your table looks like EMP
from the SCOTT
schema), is this what you want?
alter table emp add raise number; update emp set raise = sal * 1.2;
Note that if you want to increase something by 20%, then you probably want the result to be numeric rather than integer.