不挂科搜题免费

问题:

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

选项

  • select top 1 * from book order by price asC

  • select top 1 * from book order by price des

  • B.select top 1 * from book order by price desCCselect top 1 * from book where price= (select max (price)from book)

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

  • 答案:

    B、C