Consider the EMPLOYEE table, that has the following fields: ID – id number of employee, DEPARTMENT_ID – the id number of the department and SALARY – his monthly wage. What can we obtain by means of the following query:
SELECT E.*
FROM EMPLOYEE E
WHERE E.SALARY = ( SELECT MAX(SALARY) FROM EMPLOYEE E2
WHERE E2.DEPARTMENT_ID= E.DEPARTMENT_ID )

Question

Consider the EMPLOYEE table, that has the following fields: ID – id number of employee, DEPARTMENT_ID – the id number of the department and SALARY – his monthly wage. What can we obtain by means of the following query: 
  SELECT E.* 
  FROM   EMPLOYEE E 
  WHERE  E.SALARY = ( SELECT MAX(SALARY) FROM EMPLOYEE E2 
 WHERE  E2.DEPARTMENT_ID= E.DEPARTMENT_ID )

Accepted Answer

show the list of employees who earn the biggest salary in their department

Answer

show the data of  all employees

Answer

show the list of employees whose salary is greater than average

Answer

calculate the biggest salary among all employees

Answer

show the list of employees who earn the biggest salary

Crowdly

Consider the EMPLOYEE table, that has the following fields: ID – id number of em...

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