sql 如下怎么把sum函数结果都为0的数据过滤掉

Question

SELECT
sub_org_code,
sub_org_name,
SUM(half_hour_overtime_num) AS half_hour_overtime_num,
SUM(two_hour_overtime_num) AS two_hour_overtime_num,
SUM(six_hour_overtime_num) AS six_hour_overtime_num,
SUM(half_day_overtime_num) AS half_day_overtime_num,
SUM(before_fcdate_overtime_num) AS before_fcdate_overtime_num,
DATE_FORMAT(gmt_created,'%Y-%m-%d') as gmtCreated,
org_level
FROM
mpm_pcs_sort_total
WHERE
sub_org_code IS NOT NULL
AND sub_org_code <> '*'
AND gmt_created >= '2019-08-18'
AND gmt_created <= '2019-09-18'
AND parent_org_code = '000000'
GROUP BY
sub_org_code,
sub_org_name,
gmtCreated,
org_level

Answer 1

可以用 having 条件过滤 group by 后的结果，在 group by 后面加条件，demo:

GROUP BY
sub_org_code,
sub_org_name,
gmtCreated,
org_level

having half_hour_overtime_num<>0 and two_hour_overtime_num<>0 ...

如果别名不可用，就换成实际的 sum 语句，详情参考这篇：https://www.cnblogs.com/doudouxiaoye/p/5798623.html。