select name, sum(number) total from test group by name; 转载于:https://www.cnblogs.com/ai594ai/p/7365152.html