[leetcode] [SQL] Employees Earning More Than Their Managers

psy4072·2022년 10월 30일
0

SQL

목록 보기
27/33
post-custom-banner

문제 설명


문제 풀이

SELECT employee.NAME as Employee
FROM employee 
		INNER JOIN employee AS manager ON employee.managerID = manager.id
WHERE employee.salary > manager.salary

실행 결과

profile
Ⓓ🅰️🅣🄰 ♡♥︎

0개의 댓글