![](https://cos-cdn.shuashuati.com/pipixue-web/2020-1231-2005-12/ti_inject-812ce.png)
现有书目表book包含字段price (float); 现在查询一条书价最高的书目的详细信息。以下语句正确的是 。
A.
select top 1 * from book order by price asc
B.
select top 1 * from book order by price desc
C.
select top 1 * from book where price= (select min (price)from book)
D.
select top 1 * from book where price= max(price)