Programming/Oracle

case문 예제

초록깨비 2009. 9. 9. 15:45
728x90
select count(case when to_char(hiredate,'MM') ='01' then count(*) end) as jan,
          count(case when to_char(hiredate,'MM') ='02' then count(*) end) as feb
  from emp

728x90