Employees Earning More Than Their Managers
Employees Earning More Than Their Managers
문제
코드
Oracle
SELECT EMPLOYEE.NAME AS Employee
FROM EMPLOYEE
INNER JOIN EMPLOYEE AS MANAGER ON EMPLOYEE.MANAGERID = MANAGER.ID
WHERE EMPLOYEE.SALARY > MANAGER.SALARY