case문 예제

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