题目内容
(请给出正确答案)
[单选题]
从产品表Products中查询单价(字段名为UnitPrice)在6~10的产品名称(字段名为pName)和单价信息,正确的语句有()。
A.SELECT pName, UnitPrice FROM Products WHERE UnitPrice BETWEEN 6 AND 10
B.SELECT pName, UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
C.SELECT pName, UnitPrice FROM Products WHERE UnitPrice IN(6,10)
D.SELECT pName, UnitPrice FROM Products WHERE UnitPrice>=6 AND UnitPrice<=10
答案
SELECT Name , UnitPrice FROM Products WHERE UnitPrice BETWEEN 6 AND 10
如搜索结果不匹配,请 联系老师 获取答案