贤人必须成人,成人才能达己.

摘要： select c0,sum(c1) as c1,sum(c2) as c2 from (select c0,sum(c1) as c1,0 as c2 from t1 group by c0union select c0,0 as c1 ,sum(c2) as c2 from t1 group by c0) c group by c0 阅读全文