Contents

Employees Earning More Than Their Managers

   Jan 22, 2023     0 min read

Employees Earning More Than Their Managers

문제

181-1.jpg
182-2.jpg

코드

Oracle

SELECT EMPLOYEE.NAME AS Employee
FROM EMPLOYEE
    INNER JOIN EMPLOYEE AS MANAGER ON EMPLOYEE.MANAGERID = MANAGER.ID
WHERE EMPLOYEE.SALARY > MANAGER.SALARY