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
正确答案:C,D
答案解析:有
微信扫一扫手机做题