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
count(case when to_char(hiredate,'MM') ='02' then count(*) end) as feb
from emp
728x90