试题详情

现有书目表book,包含字段:price(float);现在查询一条书价最高的书目的详细信息,以下语句正确的是()

ASelect top1 * from book order by price asc

BSelect top1 * from book order by price

CSelect top1 * from book where price=(select max(price) from book)

DSelect top1 * from book where price=max(price)