SELECT dic1.CRDCT_NAME AS jcdjPsName,(
select count(*) FROM CORE_DICT dic2 LEFT JOIN JCDJ_PARTYMEMBER ON(JCDJ_PMIDENTITY_UUID=dic2.CRDCT_CHAR_CODE)
WHERE JCDJ_PMOGNCODE like CONCAT('033001026','%' ) AND dic2.CRDCT_NAME=dic1.CRDCT_NAME
) AS jcdjPsCount FROM CORE_DICT dic1 WHERE dic1.CRDCT_LEVEL_CODE LIKE '020u_%'
sql分类统计,条件中没有的为0
最新推荐文章于 2024-09-12 09:56:34 发布