结果集合并查询（union后不加all可去掉相同结果项）

SELECT SUM(Totalcnt) FROM B_Com WHERE Type1='6' AND Type2='1' GROUP BY Type1,Type2
union all
SELECT SUM(Totalcnt) FROM B_Com WHERE Type1='6' AND Type2='2' GROUP BY Type1,Type2
union all
SELECT SUM(Totalcnt) FROM B_Com WHERE Type1='6' AND Type2='3' GROUP BY Type1,Type2

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/whlhaikuotiankong/p/2455265.html