结果集合并查询(union后不加all可去掉相同结果项)
摘要:
SELECT SUM(Totalcnt) FROM B_Com WHERE Type1='6' AND Type2='1' GROUP BY Type1,Type2union allSELECT SUM(Totalcnt) FROM B_Com WHERE Type1='6' AND Type2='2' GROUP BY Type1,Type2union allSELECT SUM(Totalcnt) FROM B_Com WHERE Type1='6' AND Type2='3' GROUP BY 阅读全文
posted @ 2012-04-18 14:32 奔腾年代 阅读(312) 评论(0) 推荐(0) 编辑