部门工资前三高的所有员工
Employee
表包含所有员工信息,每个员工有其对应的工号Id
姓名Name
,工资Salary
和部门编号DepartmentId
。
Department
表包含公司所有部门的信息。
编写一个SQL查询,找出每个部门获得前三高工资的所有员工。
SELECT d.name as "Department",e1.name as "Employee",e.salary
FROM Employee as e1
J
Employee
表包含所有员工信息,每个员工有其对应的工号Id
姓名Name
,工资Salary
和部门编号DepartmentId
。
Department
表包含公司所有部门的信息。
编写一个SQL查询,找出每个部门获得前三高工资的所有员工。
SELECT d.name as "Department",e1.name as "Employee",e.salary
FROM Employee as e1
J