发布时间：2013-11-18 11:42:25
问题create table abc(A int,B int) Select A,count(B) as total from ABC group by ASelect A,count(B) as total1 from ABC where B > 30 group by ASelect A,count(B) as totlal2 from ABC where B > 20 group by A如何合并这三个查询？得到一个查询结果：A,total,total1,total2解决方案：Select A,count(B) .........【阅读全文】
