求一SQL语句

[hui1202]

a b c d e f g
2007 5 16 9 0 2 2
2007 5 16 10 0 0 0
2007 5 16 11 0 7 7
2007 5 16 12 0 0 0
2007 5 16 13 0 0 0
2007 5 16 14 1 2 22
2007 5 16 15 3 6 37
2007 5 16 16 1 2 23
2007 5 16 18 1 2 14
2007 5 16 19 1 0 21
2007 5 16 20 0 0 12
2007 5 16 21 1 3 9
2007 5 16 23 0 1 8
2007 5 17 0 2 2 27
2007 5 17 1 1 0 10
2007 5 17 2 0 0 3
2007 5 17 3 0 0 12
2007 5 17 4 1 0 15

以上的表我想取出前3列相同数据的e列，f列，g列的sum，请教如何写SQL语句

[Yang_]

select a,b,c,sum(e) as sume,sum(f) as sumf,sum(g) as sumg
from tablename
group by a,b,c

[肥胖的柠檬]

前3列相同..是什么意思?

[hui1202]

谢谢 Yang_(扬帆破浪) ( ) ，搞定