![](https://lstatic.shangxueba.com/jiandati/pc/images/pc_jdt_tittleico.png)
现有书目表book,包含字段:price(float);现在查询一条书价最高的书目的详细信息,以下语句正确的是哪两项?()
A.selecttop1*frombookorderbypriceasc
B.selecttop1*frombookorderbypricedesc
C.selecttop1*frombookwhereprice=(selectmax(price)frombook)
D.selecttop1*frombookwhereprice=max(price)
![](https://lstatic.shangxueba.com/jiandati/pc/images/jdt_q_ckda.png)
![](https://lstatic.shangxueba.com/jiandati/pc/images/jdt_panel_vip.png)
![](https://lstatic.shangxueba.com/jiandati/pc/images/jdt_q_wyda.png)
- · 有3位网友选择 A,占比27.27%
- · 有3位网友选择 D,占比27.27%
- · 有3位网友选择 C,占比27.27%
- · 有2位网友选择 B,占比18.18%