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:

Question

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:

Accepted Answer

SELECT * 
 FROM  EMPLOYEE E, EMPLOYEE M 
 WHERE  E.ID = M.MANAGER_ID  AND  E.SALARY > M.SALARY

Accepted Answer

SELECT * 
 FROM  EMPLOYEE E  JOIN  EMPLOYEE M 
 ON  E.ID = M.MANAGER_ID 
 WHERE  E.SALARY > M.SALARY

Answer

SELECT SALARY 
 FROM  EMPLOYEE E  FULL JOIN  EMPLOYEE M 
 ON  E.ID = M.MANAGER_ID 
 WHERE  E.SALARY > M.SALARY

Answer

SELECT * 
 FROM  EMPLOYEE 
 WHERE  SALARY = MAX(SALARY)

Answer

SELECT * 
 FROM  EMPLOYEE 
 HAVING  SALARY = MAX(SALARY)

Crowdly

Consider the EMPLOYEE table containing the employee’s ID, his name, salary and t...

Want instant access to all verified answers on softserve.academy?