跪求。。。帮忙写个SQL语句！！！！！！

来源：百度知道 编辑：UC知道 时间：2024/07/05 05:57:46
表pay（员工ID, 应发工资、实发工资、加班工资）；表employee(员工ID、姓名、部门id、…)；表department(部门id、部门名称、…)
要求用SQL语句：1）、查询每个部门合计的实发工资、加班工资，
2）、并按部门分组对各项工资进行合计。
3）、显示部门名称、实发工资总数、加班工资总数

1)
SELECT A.部门名称, SUM(dbo.Pay.实发工资) AS 实发工资, SUM(dbo.Pay.加班工资)
AS 加班工资
FROM (SELECT dbo.Employee.员工ID, dbo.Employee.姓名,
dbo.Department.部门名称
FROM dbo.Employee LEFT OUTER JOIN
dbo.Department ON dbo.Employee.部门ID = dbo.Department.部门ID)
A LEFT OUTER JOIN
dbo.Pay ON A.员工ID = dbo.Pay.员工ID
GROUP BY A.部门名称

三个问题的写法差不多!

select deptname,sum(实发工资) as 实发工资总数,sum(加班工资) as 加班工资总数
from pay join emp on pay.empid=emp.empid
join dept on emp.deptid=dept.deptid
group by emp.deptid,dept.deptname

SELECT department.部门名称,sum(pay.实发工资) AS 实发工资总数,sum(pay.加班工资) AS 加班工资总数
FROM pay,employee,department
WHERE department.部门id=employee.部门id
and pay.员工id=employee.员工id
GROUP BY employee.部门id;