id a b c d e f g h i
01 0 0 0 0 0 0 15 10 10
01 0 0 0 0 10 21 0 0 21
01 0 0 14 13 0 0 0 0 13
01 60 13 0 0 0 0 0 0 14
02 0 0 0 0 0 0 40 23 23
02 0 0 0 0 60 50 0 0 50
这不是很简单的吗?刚一看吓我一跳!
select id,sum(a),sum(b),sum(c) ,sum(d),sum(e),sum(f),sum(g),sum(h),sum(i)
from tbl group by id
from tbl group by idUP!
from tbl group by id;
正解
分组查询
SELECT字段名1, 字段名2, …… FROM 表名1, [表名2, ……] GROUP BY字段名1
[HAVING 条件] ;