Postgresql - BETWEEN

使用BETWEEN运算符将一个值与一系列值进行匹配

语法

value BETWEEN low AND high

如果value在low和high之间，则返回TRUE，否则返回FALSE。

BETWEEN可以使用大于等于和小于等于运算符，但是不能使用LIKE运算符。

value >= low and value <= high

检查是否超出范围，可以使用NOT和BETWEEN组合运算符。

value NOT BETWEEN low AND high

等价于

value < low OR value > high

示例

使用BETWEEN查询金额是否在 8 和 9 之间。

SELECT
    customer_id,
    payment_id,
    amount
FROM
    payment
WHERE
    amount BETWEEN 8 AND 9;

查询金额不在 8 和 9 之间。

SELECT
    customer_id,
    payment_id,
    amount
FROM
    payment
WHERE
    amount NOT BETWEEN 8 AND 9;