SQL/SQL 문제
[Leetcode] 181. Employees Earning More Than Their Managers
Lim Seung Hyun
2022. 3. 23. 15:11
문제 출처
Employees Earning More Than Their Managers - LeetCode
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
나의 풀이
select emp.name as Employee
from Employee as emp
join Employee as mgr on emp.managerId = mgr.id
where emp.salary > mgr.salary
728x90