问题
单项选择题
有如下SQL-SELECT语句 SELECT * FROM HH WHERE 单价 BETWEEN 10.6 AND 13.4 与该语句等价的是
A.SELECT * FROM HH WHERE 单价<=13.4 AND 单价>=10.6
B.SELECT * FROM HH WHERE 单价<13.4 AND 单价>10.6
C.SELECT * FROM HH WHERE 单价>=13.4 AND 单价<=10.6
D.SELECT * FROM HH WHERE 单价>13.4 AND 单价<10.6
答案
参考答案:A
解析: BETWEEN…AND…意思是在“…和…之间”,包含等于。