分享程序员开发的那些事...
更新时间：2022-09-13 21:31:35
A NOT BETWEEN B AND CA,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 aaFROM T1WHERE int1 NOT BETWEEN int2 AND int3;| aa(int) |
|---|
| 11 |
| var1(varchar) | var1(varchar) | var1(varchar) |
|---|---|---|
| d | a | c |
SELECT var1 as aaFROM T1WHERE 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 aaFROM T1WHERE TIMESTAMP1 NOT BETWEEN TIMESTAMP2 AND TIMESTAMP3;
| aa(TIMESTAMP) |
|---|
| 1969-07-20 20:17:30 |