(sql)case문 사용법

case문 사용법

 

select dept
     , case dept
               WHEN 'AA' THEN sum(1)
               WHEN 'BB' THEN sum(1)
               ELSE 0
       END as "Dept Name"
  from temp
 group by meddept