结果集合并查询（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