问题详情
现有书目表book,包含字段:price(float);现在查询一条书价最高的书目的详细信息,以下语句正确的是哪两项?()
A、selecttop1*frombookorderbypriceasc
B、selecttop1*frombookorderbypricedesc
C、selecttop1*frombookwhereprice=(selectmax(price)frombook)
D、selecttop1*frombookwhereprice=max(price)