sql group by sum

  1   select max(xzqmc2) qymc,0 as hzbs,
   2   sum(mjm) as bhmj,
   3   count(sfcl) as bhs,
   4   sum(case when sfcl=‘是‘then 1 else 0 end) ycltbs ,
   5   sum(case when sfcl=‘是‘then mjm else 0 end) ycltbmj,
   6   sum(case when sfcl=‘否‘then 1 else 0 end) wcltbs ,
   7   sum(case when sfcl=‘否‘then mjm else 0 end) wcltbmj
   8   from zz_ygyswftb where pcsid = #{pcid} group by xzqmc2
   9   union
  10   select ‘萍乡‘ qymc,1 as hzbs,
  11   sum(mjm) as bhmj,
  12   count(sfcl) as bhs,
  13   sum(case when sfcl=‘是‘then 1 else 0 end) ycltbs ,
  14   sum(case when sfcl=‘是‘then mjm else 0 end) ycltbmj,
  15   sum(case when sfcl=‘否‘then 1 else 0 end) wcltbs ,
  16   sum(case when sfcl=‘否‘then mjm else 0 end) wcltbmj
  17  from zz_ygyswftb where pcsid = #{pcid}

sql group by sum

标签：分区   rgb   ase   技术   sql   case when   where   lazy   根据   

查看更多关于sql group by sum的详细内容...