1111

SELECT A01.A01609 ,COUNT(A0190) AS "年度入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘01‘OR SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘02‘OR SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘03‘ THEN A0190 ELSE NULL END) AS "第一季度入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘04‘OR SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘05‘OR SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘06‘ THEN A0190 ELSE NULL END) AS "第二季度入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘07‘OR SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘08‘OR SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘09‘ THEN A0190 ELSE NULL END) AS "第三季度入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘10‘OR SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘11‘OR SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘12‘ THEN A0190 ELSE NULL END) AS "第四季度入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘01‘ THEN A0190 ELSE NULL END) AS "一月入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘02‘ THEN A0190 ELSE NULL END) AS "二月入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘03‘ THEN A0190 ELSE NULL END) AS "三月入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘04‘ THEN A0190 ELSE NULL END) AS "四月入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘05‘ THEN A0190 ELSE NULL END) AS "五月入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘06‘ THEN A0190 ELSE NULL END) AS "六月入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘07‘ THEN A0190 ELSE NULL END) AS "七月入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘08‘ THEN A0190 ELSE NULL END) AS "八月入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘09‘ THEN A0190 ELSE NULL END) AS "九月入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘10‘ THEN A0190 ELSE NULL END) AS "十月入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘11‘ THEN A0190 ELSE NULL END) AS "十一月入职人数",
COUNT(CASE WHEN SUBSTRING(CONVERT(VARCHAR(8),A0141,112),5,2)=‘12‘ THEN A0190 ELSE NULL END) AS "十二月入职人数"
FROM A01 WHERE CONVERT(VARCHAR(4),A0141,112)=:年度 GROUP BY A01609

1111

原文：https://www.cnblogs.com/123dsds/p/12427855.html