CASE 문법

CASE WHEN 조건 THEN 리턴값1
        WHEN 조건2 THEN 리턴값2
        ELSE 리턴값3
END

 

예제1)

SELECT ENAME, DEPTNO,

CASE WHEN DEPTNO='10' THEN 'DESIGN'

        WHEN DEPTNO='20' THEN 'DEVELOPMENT'

        ELSE 'MANAGEMENT'

END AS DEPT_NAME

FROM EMP

WHERE JOB='MANAGER';

 

ENAME	DEPTNO	DEPT_NAME
WH	10	DESIGN
SC	30	MANAGEMENT
WS	20	DEVELOPMENT