我也问个统计的SQL。想了两天了,没好的办法。
select field1,count(field2) as allDone from table1 where field3=0 group by field1;
select field1,count(field2) as allWait from table1 where field3=1 group by field1;
请高手指教怎么样才能把上面两句SQL组合成一句得到如下的结果集
列 field1 allDone allWait
数据 ... .... .....
... .... .....