sql语句提示不是单组分组函数

Question

问题相关代码，请勿粘贴截图

select a.aac001,b.aab001, b.aab073,c.aab033,a.aac999,a.aac003,b.aab999,b.aab004,c.aaa115,c.aae140,c.aae180,c.aaz192,c.aae100,sum(c.aae028) aae028,sum(c.bac121) bac121,sum(c.bac120) bac120,sum(bac120 + bac121) bac222,d.cae249, d.aae217,e.aae225,e.aae226,sum(c.aae201) aae201,sum(c.aae180) sumaae180,sum(c.aae020) aae020,sum(c.aae022) , aae022,sum(aae020 + aae022 + aae028 + bac121 + bac120) aae222 from ac01 a, ab01 b, ac42 c, ae02 d, ac40 e where a.aac001 = c.aac001 and b.aab001 = c.aab001 and c.aaz192 = e.aaz192 and d.aaz002 = e.aaz002 and c.aaz223 is null;

我想要达到的结果

我是少加了什么，一直提示不是单租分组函数

Answer 1

把你所有没做汇总的字段都group by 一下就行了

select a.aac001,
       b.aab001,
       b.aab073,
       c.aab033,
       a.aac999,
       a.aac003,
       b.aab999,
       b.aab004,
       c.aaa115,
       c.aae140,
       c.aae180,
       c.aaz192,
       c.aae100,
       sum(c.aae028) aae028,
       sum(c.bac121) bac121,
       sum(c.bac120) bac120,
       sum(bac120 + bac121) bac222,
       d.cae249,
       d.aae217,
       e.aae225,
       e.aae226,
       sum(c.aae201) aae201,
       sum(c.aae180) sumaae180,
       sum(c.aae020) aae020,
       sum(c.aae022),
       aae022,
       sum(aae020 + aae022 + aae028 + bac121 + bac120) aae222
  from ac01 a, ab01 b, ac42 c, ae02 d, ac40 e
 where a.aac001 = c.aac001
   and b.aab001 = c.aab001
   and c.aaz192 = e.aaz192
   and d.aaz002 = e.aaz002
   and c.aaz223 is null
 group by a.aac001,
          b.aab001,
          b.aab073,
          c.aab033,
          a.aac999,
          a.aac003,
          b.aab999,
          b.aab004,
          c.aaa115,
          c.aae140,
          c.aae180,
          c.aaz192,
          c.aae100,
          d.cae249,
          d.aae217,
          e.aae225,
          e.aae226,
          aae022