select type,sum(value) as valueSum from t group by type 转载于:https://www.cnblogs.com/zwqh/p/9448848.html