Question

sql server 利用SQL语句查询各部门的实发工资总数.速回有加财富

Answer 1

select 部门,sum(工资) from 表名 group by 部门

Answer 2

select 部门,sum(实发工资) as 实发工资 from table group by 部门

Answer 3

select 部门,sum(工资) from 表名 group by 部门