What is the result of the following SQL query?
SELECT ename
FROM employee
WHERE esalary = (SELECT MAX(salary)FROM employee);
A)The query displays the number that represents how many employees share the highest salary
B)The query displays the salary of the employee (or employees)with the highest salary
C)The query displays the name and the salary of the employee (or employees)with the highest salary
D)The query displays the name of the employee (or employees)with the highest salary

Question

Quizplus · Accepted Answer

The query is retrieving the name(s) of the employee(s) with the highest salary. The WHERE clause is filtering the results to only include employees whose esalary matches the value returned by the subquery, which gets the maximum salary from the employee table. Therefore, only the name(s) of the employee(s) with the highest salary will be returned.

What Is the Result of the Following SQL Query