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
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
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货