select CONVERT(varchar(7),JoinDate,120) 月份,
sum(case when 部门='software' then 1 end) software,
sum(case when 部门='hardware' then 1 end) hardware,
(select sum(1) from 员工表A where CONVERT(varchar(7),JoinDate,120)<=CONVERT(varchar(7),tem.JoinDate,120)) from 员工表A tem group by CONVERT(varchar(7),JoinDate,120)
sum(case when 部门='software' then 1 end) software,
sum(case when 部门='hardware' then 1 end) hardware,
(select sum(1) from 员工表A where CONVERT(varchar(7),JoinDate,120)<=CONVERT(varchar(7),tem.JoinDate,120)) from 员工表A tem group by CONVERT(varchar(7),JoinDate,120)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货