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/archive/2012/04/18/2455265.html