在SQL Server中，您有一个表engineers，其表结构如下：
enggid int(4)
deptname varchar(50)
salary int(4)
您想显示各个部门的最低和最高工资。下列哪项查询能得到所需的结果？ ( )
select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers
select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers group by deptname
select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers group by salary
select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers order by deptname
都不对
