语法
A NOT BETWEEN B AND C
入参
-
A,B,C
DOUBLE、BIGINT、INT、VARCHAR、DATE、TIMESTAMP、TIME类型。
功能描述
NOT BETWEEN AND
操作符用于选取不存在与两个值之间的数据范围内的值。
示例一
- 测试数据
int1(INT) | int2(INT) | int3(INT) |
---|---|---|
90 | 97 | 80 |
11 | 10 | 7 |
- 测试案例
SELECT int1 as aa
FROM T1
WHERE int1 NOT BETWEEN int2 AND int3;
- 测试结果
aa(int) |
---|
11 |
示例二
- 测试数据
var1(varchar) | var1(varchar) | var1(varchar) |
---|---|---|
d | a | c |
- 测试案例
SELECT var1 as aa
FROM T1
WHERE var1 NOT BETWEEN var2 AND var3;
- 测试结果
aa(varchar) |
---|
d |
示例三
- 测试数据
TIMESTAMP1(TIMESTAMP) | TIMESTAMP2(TIMESTAMP) | TIMESTAMP3(TIMESTAMP) |
---|---|---|
1969-07-20 20:17:30 | 1969-07-20 20:17:40 | 1969-07-20 20:17:45 |
- 测试案例
SELECT TIMESTAMP1 as aa
FROM T1
WHERE TIMESTAMP1 NOT BETWEEN TIMESTAMP2 AND TIMESTAMP3;
- 测试结果
aa(TIMESTAMP) |
---|
1969-07-20 20:17:30 |