试题详情

现有书目表 book,包含字段:price (float);现在查询一条书价最高的书目的详细信息,以下语句正确的是( )。 A.select top 1 * from book order by price as C.

Aselect top 1 * from book order by price des

Cselect top 1 * from book where price= (select max (price)from book)

Dselect top 1 * from book where price= max(price)