数据库中,between……and是求某个闭区间的值的。
工具:sqlserver 2008 R2
步骤:
1、数据库中有学生表如下:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1e30e924b899a901797bb09b17950a7b0308f5d5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、列出学号为2到4的数据,可用如下语句:
select * from 学生 where 学号 between 2 and 4;
3、查询结果:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f636afc379310a55a1a43559bd4543a98326109e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
操作符 BETWEEN ... AND 会选取介于两个值之间的数据范围。这些值可以是数值、文本或者日期。
基本语法:
SELECT column_name(s)
FROM table_name
WHERE column_name
BETWEEN value1 AND value2