运算符 列名*1.1 case when... then ..when.. then ..else.. end

select  ENAME as '姓名',SAL as '原始工资', (SAL*1.1) as '涨工资10%'from emp where job='MANAGER';

 

 

#  经理涨薪%10，销售涨薪%50 其余不变 需要使用  case  when then when then else end
select 
    ename,
    job,
    sal as '原来的薪水',
    (case when job='MANAGER'then SAL*1.1 when job='SALESMAN' then sal*1.5 else sal end)as '最新的薪水'
from
    emp;