create view Dep_ MSalary as

select 部门名称,salary.月份,max(sum(salary.工资)) 最高工资,min(sum(salary.工资)) 最低工资

from Employee,Departments,Salary

where Employee.员工ID = Salary.员工ID

and Employee.部门ID = Departments.部门ID

group by 部门名称 ,salary.月份

如果需要限定 月份，则为：

create view Dep_ MSalary as

select 部门名称,max(sum(salary.工资)) 最高工资,min(sum(salary.工资)) 最低工资

from Employee,Departments,Salary

where Employee.员工ID = Salary.员工ID

and Employee.部门ID = Departments.部门ID

and salary.月份 = xxx

group by 部门名称

本文地址： http://www.goggeous.com/20250104/1/1180797

文章来源：天狐定制

版权声明：除非特别标注，否则均为本站原创文章，转载时请以链接形式注明文章出处。