[leetcode] Department Top Three Salaries

最新推荐文章于 2024-09-14 08:15:15 发布

cocolalala

最新推荐文章于 2024-09-14 08:15:15 发布

阅读量1.1k

点赞数

分类专栏： database 文章标签： mysql 数据库

本文链接：https://blog.csdn.net/yezizp/article/details/43155161

版权

database 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

简单连接统计~~

select d.Name as Department,
ee.Name as Emplyee,
ee.Salary as Salary
from Department d,(
    select * from Employee e
    where (select count(distinct Salary) from Employee
            where DepartmentId = e.DepartmentId
            and Salary > e.Salary) < 3) ee
where ee.DepartmentId = d.Id
order by d.Name, ee.Salary;