ID 　部门　　分数　　

1 a 3

2 b 5

3 a 6

4 c 3

5 b 7


如何汇总各部门的分数。请各位高手帮帮忙。谢谢!!!!!急！！！急！！！急！！！

select 部门,sum(分数) as 分数
from tablename
group by 部门

非常感谢！谢谢！

错误类型：
Microsoft VBScript 编译器错误 (0x800A03FD)
缺少 'Case'
/jrxxtj.asp, line 142, column 7
select zgbm,sum("fs") as fs from jrxxb group by zgbm　
------^

select name,sum(score) from score group by name

select zgbm,sum(fs) as fs from jrxxb group by zgbm