Question

sql单表查询之分类汇总。

我用"SELECT sb_czlx as 类别, wxyh_jb as 级别, count(*) AS 次数, sum(wx_jinghui) AS 经费 FROM wxinfo GROUP BY sb_czlx, wxyh_jb" 得到结果如图，现在想把 维修和保护两类分别汇总（包括次数和经费），然后再总体汇总，请问如何写查询语句？

Answer 1

用union all合并就OK了
SELECT sb_czlx as 类别, wxyh_jb as 级别, count(*) AS 次数, sum(wx_jinghui) AS 经费 FROM wxinfo GROUP BY sb_czlx, wxyh_jb
union all
SELECT sb_czlx as 类别, null as 级别, count(*) AS 次数, sum(wx_jinghui) AS 经费 FROM wxinfo GROUP BY sb_czlx

Answer 2

SELECT sb_czlx as 类别, count(*) AS 次数, sum(wx_jinghui) AS 经费 FROM wxinfo GROUP BY sb_czlx

Answer 3

再嵌套一个select ..from

追问

怎么做，请写个完整的语句。