当前学科:结构化查询语言(SQL)
  • 题目: 多选
    现有书目表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)

    答案: <查看本题扣1积分>

    查看答案

    答案不对?请尝试站内搜索