select empID, max( empName), trunc( eDate,'MM')
sum(decode(SB,'迟到',1) cd, sum( decode(XB,'早退',1) ) zt
from Employee
group by empID, trunc( eDate,'MM')
sum(decode(SB,'迟到',1) cd, sum( decode(XB,'早退',1) ) zt
from Employee
group by empID, trunc( eDate,'MM')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货