Питання | Сторінка 122254

Consider the EMPLOYEE table containing the employee’s ID, his name, salary and the ID number of his manager.

Check the queries which produce the information about employees who earn more than their managers:

SELECT SALARY

FROM EMPLOYEE E FULL JOIN EMPLOYEE M

ON E.ID = M.MANAGER_ID

WHERE E.SALARY > M.SALARY

SELECT *

FROM EMPLOYEE E JOIN EMPLOYEE M

ON E.ID = M.MANAGER_ID

WHERE E.SALARY > M.SALARY

SELECT *

FROM EMPLOYEE E, EMPLOYEE M

WHERE E.ID = M.MANAGER_ID AND E.SALARY > M.SALARY

SELECT *

FROM EMPLOYEE

HAVING SALARY = MAX(SALARY)

SELECT *

FROM EMPLOYEE

WHERE SALARY = MAX(SALARY)

Переглянути це питання

Crowdly