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