DBI202Xuất hiện trong 1 đề thi
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?
Các lựa chọn
ASelect employeename, dept_code, salary From employee Where employee.salary in (select (salary) from Employee group by dept_code having Max(salary))
BSelect employeename, dept_code, salary From employee Where employee.salary in (select Max(salary) from Employee group by dept_code )
CSelect employeename, dept_code, salary From employee Where employee.salary in (select Max(salary) from Employee group by dept_code having Max(salary))
DSelect employeename, dept_code, salary From employee Where employee.salary =(select Max(salary) from Employee group by dept_code.