统计各部门工职总和

id name 部门 位置 工资
1 peter sales staff 2500
2 victor service manager 4000
...
统计各部门工职总和什么写请教各位了,谢谢!
[126 byte] By [xmltable] at [2008-4-11]
# 1
统计各部门工资总和什么写请教各位了,谢谢!
xmltable at 2007-10-25 > top of Msdn China Tech,MS-SQL Server,基础类...
# 2
order by 分组count就行了
kkkk17100-新vb at 2007-10-25 > top of Msdn China Tech,MS-SQL Server,基础类...
# 3
select 部门,sum(工资) as 工资 from table group by 部门
hellowork-一两清风 at 2007-10-25 > top of Msdn China Tech,MS-SQL Server,基础类...
# 4
select sum(工资) as 工资 from TableName group by 部门
csdnweii-庸医 at 2007-10-25 > top of Msdn China Tech,MS-SQL Server,基础类...
# 5
select 部门,sum(工资) as 工资和 from 表 group by 部门
# 6
select 部门,sum(工资) as 工资总和 from TableName group by 部门
csdnweii-庸医 at 2007-10-25 > top of Msdn China Tech,MS-SQL Server,基础类...
# 7
写错,应该 是
select sum(工资) from database
GROUP BY 部门
kkkk17100-新vb at 2007-10-25 > top of Msdn China Tech,MS-SQL Server,基础类...
# 8
select 部门,sum(工资) as 工资总和 from TableName group by 部门
lizhongheng-鲲鱼 at 2007-10-25 > top of Msdn China Tech,MS-SQL Server,基础类...
# 9
这种问题,不问也罢
hillhx-曾经的曾经 at 2007-10-25 > top of Msdn China Tech,MS-SQL Server,基础类...
# 10
食之无味,弃之可惜...