创建数据集中使用了union all,数据不对

有点意思，围观

看看sql

SELECT hsdw, cpx, xsyssdq, khmc, tjkhmc, htslm, 0 prehtslm,zrmbje,CAST(FORMAT(shrq, 'yyyy-MM') + '-01' AS DATE) AS shrq into #a
FROM EDA_ODS_Yxgl_Yxmljdsj
WHERE YEAR(shrq) = year(getdate()) AND MONTH(shrq) = 11
union all
SELECT hsdw, cpx, xsyssdq, khmc, tjkhmc, 0 htslm, htslm prehtslm,zrmbje,CAST(FORMAT(shrq, 'yyyy-MM') + '-01' AS DATE) AS shrq
FROM EDA_ODS_Yxgl_Yxmljdsj
WHERE YEAR(shrq) = year(getdate())-1 AND MONTH(shrq) = 11

select * from #a
select sum(htslm)htslm,sum(prehtslm)prehtslm from  #a

显示的结果是错误的，但去掉union all  是对的

单独执行试一下，看看是否有重复数据，SELECT hsdw,
       cpx,
       xsyssdq,
       khmc,
       tjkhmc,
       htslm,
       0 prehtslm,
       zrmbje,
       CAST(FORMAT(shrq, 'yyyy-MM') + '-01' AS DATE) AS shrq
  into #a
  FROM EDA_ODS_Yxgl_Yxmljdsj
WHERE YEAR(shrq) = year(getdate())
   AND MONTH(shrq) = 11;

SELECT hsdw,
       cpx,
       xsyssdq,
       khmc,
       tjkhmc,
       0 htslm,
       htslm prehtslm,
       zrmbje,
       CAST(FORMAT(shrq, 'yyyy-MM') + '-01' AS DATE) AS shrq
  into #a
  FROM EDA_ODS_Yxgl_Yxmljdsj
WHERE YEAR(shrq) = year(getdate()) - 1
   AND MONTH(shrq) = 11;