plsql 查询工资高于本部门平均工资的员工号e_id,员工姓名e_name,部门号d_id,工资money,并按照部门降序

2025-03-23 16:29:51
推荐回答(1个)
回答1:

Select e_Id 员工号, e_Name 姓名, d_Id 部门号, Money 工资
From Employees
Where Money > (Select Avg(Money) From Employees)
Order By d_Id Desc