在SQL Server中,考虑以下雇员表(employees)结构:
empid int(4)
deptname varchar(50)
salary int(4)
使用哪个查询可以显示给出最高工资的部门(deptname)?( )
select deptname from employees where salary =max(salary)
select deptname from employees where salary =max(salary) group by deptname
select deptname from employees where salary = (select salary from employees group by salary)
select deptname from employees where salary =(select max(salary) from employees)
select deptname from employees where salary in (select salary from employees group by salary)
select deptname from employees where max(salary) in (select salary from employees group by salary)