Submit My Question - Recent Questions - Recent Answer
Msdn China Tech >> MS-SQL Server >> 基础类

统计各部门工职总和

id name 部门 位置 工资
1 peter sales staff 2500
2 victor service manager 4000
...
统计各部门工职总和什么写请教各位了，谢谢!
[126 byte] By [xmltable] at [2008-4-11]
«« HELLO!
»» 读写远程计算机上文件的问题
# 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 部门
libin_ftsafe-子陌红尘-TSforBankingCard at 2007-10-25 > top of Msdn China Tech,MS-SQL Server,基础类...
# 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
食之无味,弃之可惜...
specialsoldier-雪地撒野~噢姐姐,我要回家 at 2007-10-25 > top of Msdn China Tech,MS-SQL Server,基础类...
MS-SQL Server
基础类

MS-SQL Server Hot Topic

MS-SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified