有如下SQL-SELECT语句 SELECT * FROM HH WHERE 单价 BETWEEN 10.6 AND 13.4 与该语句等价的是

admin2010-11-26  27

问题 有如下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匒ND呉馑际窃"吅蛥之间",包含等于。
转载请注明原文地址:https://jikaoti.com/ti/6ue0FFFM
0

最新回复(0)