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
此内容由惯性聚合(RSS阅读器)自动聚合整理,仅供阅读参考。 原文来自 — 版权归原作者所有。