有如下sQLSELECT语句SELECT*FROMstockWHERE单价BET

题库2022-08-02  20

问题 有如下sQLSELECT语句SELECT*FROMstockWHERE单价BETWEENl2.76ANDl5.20与该语句等价的是A.SELECT*FROMskWHERE单价<=15.20.AND.单价>一12.76B.SELECT*FROMskWHERE单价<15.20.AND.单价>12.76C.SELECT*FROMskWHERE单价>一15.20.AND.单价<一12.76D.SELECT*FROMskWHgRE单价>15.20.AN单价<12.76

选项 A.SELECT*FROMskWHERE单价<=15.20.AND.单价>一12.76
B.SELECT*FROMskWHERE单价<15.20.AND.单价>12.76
C.SELECT*FROMskWHERE单价>一15.20.AND.单价<一12.76
D.SELECT*FROMskWHgRE单价>15.20.AN单价<12.76

答案 A

解析 BETWEEN…AND…描述的是闭区间,所以与A等效。
转载请注明原文地址:https://tihaiku.com/yiliaoweisheng/2390291.html

最新回复(0)