SQL-11-SWITCH ~ CASE : CASE에 따른 값 출력

-- SWITCH ~ CASE : CASE        
SELECT case 10                 
	when 1 then 'A'             
	when 5 then 'B'             
	when 10 then 'C'            
	ELSE '?'                    
END;

 

 

emp 테이블

 

 

SELECT ENAME, DEPTNO,                      
	case when deptno=10 then 'Accounting'   
		  when deptno=20 then 'Reserch'      
		  when deptno=30 then 'Sales'        
	 	  WHEN deptno=40 then 'Operation'    
	END AS dname                            
FROM emp;