小白~专栏

做个临时表，就一个字段，里面存的是 1-12。

select m.tmonth as 月份,
sum(decode(t.type,'病假',t.days,0)) as 病假,
sum(decode(t.type,'事假',t.days,0)) as 事假,
sum(decode(t.type,'婚假',t.days,0)) as 婚假,
sum(decode(t.type,'旷工',t.days,0)) as 旷工
from test_shigu_month m left outer join test_kaoqin_recode t
on nvl(to_char(to_date(t.time,'yyyy-mm-dd'),'mm'),0) = m.tmonth and t.empid='1'
group by m.tmonth
order by m.tmonth

这样写 就能把没有值的弄成0 了。