当前学科:结构化查询语言(SQL)
  • 题目: 多选
    Northwind数据库中有一名为Products的表用于存放所有产品的信息,现在要想列出所有单价(UnitPrice)在20和40元之间的产品信息,则下列满足要求的SQL语句有()

      A . SELECT * FROM Products WHERE UnitPrice >= 20 OR UnitPrice <= 40
      B . SELECT * FROM Products WHERE UnitPrice BETWEEN 20 OR 40
      C . SELECT * FROM Products WHERE UnitPrice >= 20 AND UnitPrice <= 40
      D . SELECT * FROM Products WHERE UnitPrice BETWEEN 20 AND 40

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

    查看答案

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