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