高频 SQL 50 题（基础版）_185. 部门工资前三高的所有员工

最新推荐文章于 2025-04-02 20:48:55 发布

TTXS123456789ABC

最新推荐文章于 2025-04-02 20:48:55 发布

阅读量87

点赞数 2

分类专栏： # A_SQL 文章标签： sql 数据库

本文链接：https://blog.youkuaiyun.com/qq_45972323/article/details/146160361

版权

A_SQL 专栏收录该内容

49 篇文章

订阅专栏

在这里插入图片描述

select Department.name as Department , t2.name as Employee   , t2.salary
from  (select *
from(select id ,name  ,salary ,departmentId ,dense_rank() over(partition by departmentId  order by Salary desc) as ranke
    from Employee)as t1
where ranke<=3) as t2 
left join Department on Department.id = t2.departmentId