在SQL Server中,您有一个engineers表,其表结构如下:
enggid int(4)
name varchar(50)
salary int(4)
您想从工资最高的工程师开始,按工资递减顺序选出工资最高的2名工程师。以下哪个SQL查询可以获取该数据?( )
SELECT TOP 2 * FROM engineers ORDER BY max(salary) DESC
SELECT TOP 2 * FROM engineers ORDER BY salary DESC, GROUP BY salary
SELECT TOP 2 * FROM engineers GROUP BY salary DESC
SELECT TOP 2 * FROM engineers ORDER BY salary DESC