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

时间:2022-10-23 00:57:17 所属题库:结构化查询语言(SQL)题库

相似题目