181. Employees Earning More Than Their Managers (LeetCode)

minllny·2024년 3월 21일


답 쿼리입니다.

SELECT E1.NAME EMPLOYEE
FROM EMPLOYEE E1
     JOIN EMPLOYEE E2 ON E1.MANAGERID = E2.ID
WHERE E1.SALARY > E2.SALARY

오랜만에 조인을 하니 어색하네요 ㅋㅋ

profile
SQL 끄적끄적

0개의 댓글