BETWEEN ADN 用于判断某个字段的值是否在指定的范围之内,如果字段的值在指定的范围内,则满足条件
-
SELECT * | 字段名1 | 字段名2
-
FROM 表名
-
WHERE 字段名 [NOT] BETWEEN 值1 AND 值2
select * from student WHERE stuID BETWEEN 1 and 3
BETWEEN ADN 用于判断某个字段的值是否在指定的范围之内,如果字段的值在指定的范围内,则满足条件
SELECT * | 字段名1 | 字段名2
FROM 表名
WHERE 字段名 [NOT] BETWEEN 值1 AND 值2
select * from student WHERE stuID BETWEEN 1 and 3