数据库:MySQL8.0.18
select
sci.province,
sci.war_area,
sci.org_code,
sum(case when mt.subject='收入' then mt.amount else 0 end) as income_target_amount, -- 收入目标
sum(case when mt.subject='毛利' then mt.amount else 0 end) as gross_target_amount -- 毛利目标
from sap_center_month_target mt
left join sap_center_info sci on sci.org_code = mt.org_code
where 1=1
-- and mt.subject='收入'
and concat(year,'-',month) >=LEFT('2022-01-01',7)
and concat(year,'-',month) <=LEFT('2022-09-26',7)
group by
sci.province,
sci.war_area,
sci.org_code
这是两次执行的同一段sql,多次执行后发现,得到的值每次都会发生变化,这就很让人郁闷了,在同事的帮助下,发现是因为case when else null的问题,把null改为0就好了。原因不详。