Kizspy | Question: 28 (Choose 1 answer)
Which one of the following SQL statements returns the name of the employee (employeename, dept_code,
salary) receiving the maximum salary in a particular department?
A. Select employeename, dept_code, salary From employee Where employee.salary in (select (salary) from Employee group by dept_code having Max(salary))
B. Select employeename, dept_code, salary From employee Where employee.salary in (select Max(salary)from Employee group by dept_code)
C. Select employeename, dept_code, salary From employee Where employee.salary in (select Max(salary)from Employee group by dept_code having Max(salary))
D. Select employeename, dept_code, salary From employee Where employee.salary =(select Max(salary)from Employee group by dept_code.
