我只有 1 个名为EMPLOYEE在我的数据库中包含以下 3 列:
Employee_Name, Employee_Salary, Department_ID
现在我必须选择每个工资高于其部门平均水平的员工。我怎么做?
我遇到的主要问题是,当将每个 Employee_Salary 与
SELECT AVG(department_ID) FROM employee GROUP BY Department_ID
内部队列的返回集返回多行。
我认为我需要执行连接操作,但我不知道如何执行。
请尝试以下查询
Select * from employee a where Employee_Salary > (select avg(Employee_Salary) from
employee b group by Department_ID having b.Department_ID = a.Department_ID)
or
Select * from employee a where Employee_Salary> (select avg(Employee_Salary) from
employee b where b.Department_ID = a.Department_ID group by Department_ID)
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)