现有书目表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 max (price)from book)
- D、select top 1 * from book where price= max(price)
正确答案:B,C
答案解析:有
微信扫一扫手机做题