Lim Seunghyun Space

[Leetcode] 181. Employees Earning More Than Their Managers 본문

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
저작자표시 (새창열림)

'SQL > SQL 문제' 카테고리의 다른 글

[Leetcode] 183. Customers Who Never Order  (0) 2022.03.23
[Leetcode] 182. Duplicate Emails  (0) 2022.03.23
[HackerRank] Type of Triangle  (0) 2021.11.30
[HackerRank] The PADS  (0) 2021.11.29
[HackerRank] Employee Salaries  (0) 2021.11.22
'SQL/SQL 문제' Related Articles more