SQLServer BETWEEN
SQL Server BETWEEN运算符用于检索SELECT,INSERT,UPDATE或DELETE语句中指定范围内的值。
语法:
expression BETWEEN value1 AND value2;
参数说明
表达式: 它指定列或计算。
值1和值2: 这些值指定表达式用于比较的包含范围。
具有数值的BETWEEN运算符
从表" Employees"中检索ID在7到13之间的所有雇员。
SELECT *
FROM [lidihuo].[dbo].[Employees]
WHERE id BETWEEN 7 AND 13;
输出:
OR
SELECT *
FROM [lidihuo].[dbo].[Employees]
WHERE id >= 7
AND id <= 13;
输出:
带有NOT运算符的BETWEEN运算符
从表" Employees"中检索所有满足以下BETWEEN NOT条件的员工。
SELECT *
FROM [lidihuo].[dbo].[Employees]
WHERE id NOT BETWEEN 7 AND 11;
输出:
OR
SELECT *
FROM [lidihuo].[dbo].[Employees]
WHERE id < 7
OR id > 11;
输出: