首先根据PRO_CODE,IDN_ENTITY_TYPE分组,然后在分组后的结果中统计符合RESULT='S'
的数量和符合RESULT='F'的数量 ,并查询不参与分组的字段
SELECT
MAX (TA_CODE) AS TA_CODE,
MAX (TA_NAME) AS TA_NAME,
PRO_CODE,
MAX (PRO_NAME) AS PRO_NAME,
COUNT (*) AS checkResultNumber,
IDN_ENTITY_TYPE,
SUM(CASE WHEN CHECK_RESULT='S' THEN 1 ELSE 0 END) checkSuccess, //符合条件统计数+1 不符合+0
SUM(CASE WHEN CHECK_RESULT='F' THEN 1 ELSE 0 END) checkFail
FROM
RPT_COMPLIANCE_CHECK
WHERE
GROUP BY
PRO_CODE,
IDN_ENTITY_TYPE