![](https://cos-cdn.shuashuati.com/pipixue-wap/2020-1230-1107-53/ti_inject-812ce.png)
数据库中有"商品"表如下:要查找出"40"号部门单价最高的前两条记录,正确的SQL语句是()?
A.
SELECT TOP 2 * FROM 商品 WHERE 部门号="40" GROUP BY 单价;
B.
SELECT TOP 2 * FROM 商品 WHERE 部门号="40" GROUP BY 单价 DESC;
C.
SELECT TOP 2 * FROM 商品 WHERE 部门号="40" ORDER BY 单价;
D.
SELECT TOP 2 * FROM 商品 WHERE 部门号="40" ORDER BY 单价 DESC;