A.SELECT * FROM 商品 WHERE 单价 BETWEEN 3000 AND 10000;
B.SELECT * FROM 商品 WHERE 单价 BETWEEN 3000 TO 10000;
C.SELECT * FROM 商品 WHERE 单价 BETWEEN 3000 AND 9999;
D.SELECT * FROM 商品 WHERE 单价 BETWEEN 3000 TO 9999;
热度🔥750
参考答案:C
解析:
【解析】在查询准则中比较运算符"Between … And"用于设定范围,表示"在……之间",此题要求查找大于等于3000,小于10000的记录,因为不包括10000,所以设定的范围为Between 3000 And 9999,表达式为 SELECT * FROM 商品 WHERE 单价 BETWEEN 3000 AND 9999,答案C)正确。
复制题目向AI提问
,要查找出单价大于等于3000并且小于10000的记录,正确的SQL命令是( )。
A.SELECT * FROM 商品 WHERE 单价 BETWEEN 3000 AND 10000;
B.SELECT * FROM 商品 WHERE 单价 BETWEEN 3000 TO 10000;
C.SELECT * FROM 商品 WHERE 单价 BETWEEN 3000 AND 9999;
D.SELECT * FROM 商品 WHERE 单价 BETWEEN 3000 TO 9999;
答案:C。
解析:【解析】在查询准则中比较运算符"Between … And"用于设定范围,表示"在……之间",此题要求查找大于等于3000,小于10000的记录,因为不包括10000,所以设定的范围为Between 3000 And 9999,表达式为 SELECT * FROM 商品 WHERE 单价 BETWEEN 3000 AND 9999,答案C)正确。">
content_copy