![](https://cos-cdn.shuashuati.com/pipixue-wap/2020-1230-1107-56/ti_inject-812ce.png)
设有订单表order(其中包括字段;订单号、客户号、职员号、签订日期、金额),若要查询2012年所签订单 的信息,并按金额降序排序,正确的SQL语句是()。
A.
SELECT* FROM order WHERE YEAR(签订日期)=2012 ORDER BY金额DESC
B.
SELECT* FROM order WHILE YEAR(签订日期)=2012 ORDER BY 金额ASC
C.
SELECT * FROM order WHERE YEAR(签订日期=2012ORDER BY金额ASC
D.
SELECT*FROM order WHILE YEAR(签订日期)=2012ORDER BY 金额DESC