hyezdata 님의 블로그

Department Highest Salary 본문

코딩테스트

Department Highest Salary

hyezdata 2026. 5. 6. 11:19 
# 각 부서마다 가장 높은 연봉 받는 employee
select d.name as Department, e.name as Employee, e.salary as Salary
from (
    select name, salary, departmentId,
        dense_rank() over (partition by departmentId order by salary desc) as rnk
    from Employee
) e left join department d on e.departmentId=d.id
where e.rnk=1

 

 

 

Department Highest Salary - LeetCode

Can you solve this real interview question? Department Highest Salary - Table: Employee +--------------+---------+ | Column Name | Type | +--------------+---------+ | id | int | | name | varchar | | salary | int | | departmentId | int | +--------------+---

leetcode.com

 

728x90
반응형

'코딩테스트' 카테고리의 다른 글

Delete Duplicate Emails  (0) 2026.05.06
Department Top Three Salaries  (0) 2026.05.06
Nth Highest Salary  (0) 2026.05.01
180. Consecutive Numbers  (0) 2026.05.01
178. Rank Scores  (0) 2026.04.30
'코딩테스트' Related Articles more