SQL DECODE

--decode(식, 조건, 결과, 조건, 결과, 조건, 결과)
select empno, ename, decode
(deptno,
 10, '영업', 20, '기획', 30,'개발') as result
from emp;

--decode(식, 조건,결과,조건,결과,기본값) 
select empno, ename, decode
(deptno, 10, '영업','개발') as result
from emp;

--Q.10번부서의 급여는 10%인상, 20번부서는 20%인상,
--  나머지 부서는 동결
select empno, ename,  sal, deptno, decode(
deptno, 10, sal*1.1, 20, sal*1.2, sal) as salup
from emp;


--Q.각 직업별 급여 인상
select empno, ename, job, sal, decode(job, 
'ANALYST', sal*1.05,
'SALESMAN', sal*1.1,
'MANAGER', sal*1.15,
'CLERK', sal*1.2, sal) as upsal
from emp;