0
|
touyuan001Lv6中级互助发布于2020-7-31 11:35(编辑于 2020-7-31 11:36)
|
1、数据集里面通过条件筛选 2、通过条件属性设置行高为0
|
-
用户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=\'${特殊工艺类型}\'
-
用户e7189508(提问者)
- 是这样筛选吗
-
touyuan001 回复 用户e7189508(提问者)
- 是的,建议是这种,在数据集里面,条件过滤的方式
-
用户e7189508(提问者) 回复 touyuan001
- 但是这样查询不到数据啊
|
|