数据库中有"商品"表如下:
,要查找出单价大于等于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;
热度🔥719
解析:打开微信小程序查看本题解析