查出每个部门大于平均工资的员工姓名,所在部门名称,工资的sql语句怎么写

2025-03-23 04:11:28
推荐回答(1个)
回答(1):

Select * from Staff Where Salary >
(
select AVG(Salary) from Staff
Group By Salary
)