用户e7189508(提问者) SELECT specialprocess_type, specialprocess_number, approvalprocess_type, COUNT( supplier_name ) AS 供应商总数, count( IF ( supplier_status = \'正常\', TRUE, NULL ) ) AS 正常, count( IF ( supplier_status = \'提升\', TRUE, NULL ) ) AS 提升, count( IF ( supplier_status = \'受限\', TRUE, NULL ) ) AS 受限, count( IF ( supplier_status = \'淘汰\', TRUE, NULL ) ) AS 淘汰, count( IF ( linebody_level = \'A\', TRUE, NULL ) ) AS A级, count( IF ( linebody_level = \'B\', TRUE, NULL ) ) AS B级, count( IF ( linebody_level = \'C\', TRUE, NULL ) ) AS C级, count( IF ( linebody_level = \'D\', TRUE, NULL ) ) AS D级, count( IF ( homemade_outsourced = \'zz\', TRUE, NULL ) ) AS 自制数量 FROM spa_processrecognition GROUP BY supplier_name, specialprocess_number, approvalprocess_type, homemade_outsourced HAVING homemade_outsourced = \'${自制/外包}\' and approvalprocess_type=\'${认可工艺类型}\' and specialprocess_type=\'${特殊工艺类型}\'

回复

2020-07-31 11:38 

取消 回复

用户e7189508(提问者) 是这样筛选吗

回复

2020-07-31 11:38 

取消 回复

touyuan001 回复 用户e7189508(提问者) 是的，建议是这种，在数据集里面，条件过滤的方式

回复

2020-07-31 11:40 

取消 回复

用户e7189508(提问者) 回复 touyuan001 但是这样查询不到数据啊

回复

2020-07-31 12:05 

取消 回复