SQL Inclusive Operator 包含运算符

在比较时把边界值本身也算进来的运算符。 跟 exclusive operator 相对。

例子

-- BETWEEN 是 inclusive
SELECT * FROM events 
WHERE score BETWEEN 5 AND 10;
-- 等价于 score >= 5 AND score <= 10
-- 5 和 10 都被选中

<= 和 >= 也是 inclusive。

跟 exclusive 对比

operator	含义
BETWEEN 5 AND 10 (inclusive)	5 ≤ x ≤ 10
> 5 AND < 10 (exclusive)	5 < x < 10,不含 5、10

写查询时一定要看清楚边界 —— “本月数据” 是 < 2026-06-01 还是 <= 2026-05-31?算错一天就是 bug。