between
between介绍
expr1 [NOT] BETWEEN expr2 AND expr3 - 判断 expr1 是否 [不] 在 expr2 和 expr3 之间。
Examples:
> SELECT col1 FROM VALUES 1, 3, 5, 7 WHERE col1 BETWEEN 2 AND 5;
3
5
Since: 1.0.0
expr1 [NOT] BETWEEN expr2 AND expr3 - 判断 expr1 是否 [不] 在 expr2 和 expr3 之间。
Examples:
> SELECT col1 FROM VALUES 1, 3, 5, 7 WHERE col1 BETWEEN 2 AND 5;
3
5
Since: 1.0.0