MYSQL中的字段数据相加

[taopeipei]

table:
Id month num1 num2 member
1 2007-01 10 8 1
2 2007-01 20 5 3
3 2007-01 30 2 2
4 2007-02 80 5 2
5 2007-02 60 2 1
6 2007-01 50 15 3
7 2007-01 40 10 3
8 2007-01 20 17 3

现在想将表按照member字段分组查出num2的和
结果：
member num2的和
1 10
2 7
3 47

[runer]

select member,sum(num2) from table group by member

[strive_bo]

select member,sum(num2) from table group by member

[skycb]

select member,sum(num2) from table group by member

[ma309385560]

select member,sum(num2) from table group by member

[luman2002]

以上都对

[yingzhuo2011]

select member,sum(num2) from table group by member

[ronniegxq]

select member,sum(num2) from table group by member

[wolfkoala]

[Quote=引用 1 楼 runer 的回复:]

select member,sum(num2) from table group by member
[/Quote]


nice