从产品表 Products 中查询单价 UnitPrice 在 6~10 的产品名称和单价信息,正确的 SQL有()
A.
SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 6 AND 10
B.
SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
C.
SELECT Name, UnitPrice FROM Products WHERE UnitPrice IN( 6, 10)
D.
SELECT Name,UnitPrice FROM Products WHERE UnitPrice>= 6 OR UnitPrice <=10< /div>