【SQL】185. Department Top Three Salaries
标签：logs rom company from ane tab sam aries sel
【SQL】185. Department Top Three Salaries
# Write your MySQL query statement below
2 select d.Name as Department,e.Name as Employee,e.Salary
3 from Department d,Employee e
4 where d.Id=e.DepartmentId
5 and 3>(
6 select count(distinct Salary)
7 from Employee
8 where Salary>e.Salary
9 and DepartmentId = e.DepartmentId
10 );