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