从产品表Products中查询单价UnitPrice在6~10（包含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 AND UnitPrice<=10
参考答案：
SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 6 AND 10；SELECT Name,UnitPrice FROM Products WHERE UnitPrice>=6 AND UnitPrice<=10
2023-06-18
加载更多~