各位大虾,请帮忙啊。。
A B C D E F G H M N
2012-10-15 730 0 0 0 0 2012121 184 0 184
2012-10-15 730 0 0 2012282 192 0 0 0 0
2012-10-15 730 0 0 0 0 0 0 2012282 0
想通过sql语句变成
A B C D E F G H M N
2012-10-15 730 0 0 2012282 192 2012121 184 2012282 184
请大家帮忙看看SQL怎么写哦。。
A B C D E F G H M N
2012-10-15 730 0 0 0 0 2012121 184 0 184
2012-10-15 730 0 0 2012282 192 0 0 0 0
2012-10-15 730 0 0 0 0 0 0 2012282 0
想通过sql语句变成
A B C D E F G H M N
2012-10-15 730 0 0 2012282 192 2012121 184 2012282 184
请大家帮忙看看SQL怎么写哦。。
select a, sum(b), sum(c),sum(d),sum(e),sum(f),sum(g),sum(h),sum(m),sum(n)
from tablename group by a
A B C D E F G H M N
2012-10-15 730 0 0 0 0 2012121 184 0 184
2012-10-15 730 0 0 2012282 192 0 0 0 0
2012-10-15 730 0 0 0 0 0 0 2012282 0
2012-10-16 0731 0 0 0 0 0 0 2012283 0
2012-10-16 0731 2012122 2596 0 0 0 0 0 0
2012-10-16 0731 0 0 0 0 0 0 2012283 0
2012-10-16 0731 0 0 2012283 80 0 0 0 0
2012-10-16 0731 2012122 35048 0 0 0 0 0 0变成这样子的2012-10-15 730 0 0 2012282 192 2012121 184 2012282 184
2012-10-16 0731 2012122 37644 2012283 80 0 0 2012283 0
SELECT A,B,MAX(C),SUM(D),MAX(E),SUM(F),MAX(G),SUM(H),MAX(M),SUM(N) FROM YOURTABLE GROUP BY A ,B
谢谢各位