语法
A BETWEEN B AND C
入参
-
A，B，C
DOUBLE，BIGINT，INT，VARCHAR，DATE，TIMESTAMP，TIME 类型。
功能描述
BETWEEN操作符用于选取介于两个值之间的数据范围内的值。
示例一
- 测试数据
| int1(INT) | int2(INT) | int3(INT) |
|---|---|---|
| 90 | 80 | 100 |
| 11 | 10 | 7 |
- 测试案例
SELECT int1 as aaFROM T1WHERE int1 BETWEEN int2 AND int3;
- 测试结果
| aa(int) |
|---|
| 90 |
示例二
- 测试数据
| var1(varchar) | var1(varchar) | var1(varchar) |
|---|---|---|
| b | a | c |
- 测试案例
SELECT var1 as aaFROM T1WHERE var1 BETWEEN var2 AND var3;
- 测试结果
| aa(varchar) |
|---|
| b |
示例三
- 测试数据
| TIMESTAMP1(TIMESTAMP) | TIMESTAMP2(TIMESTAMP) | TIMESTAMP3(TIMESTAMP) |
|---|---|---|
| 1969-07-20 20:17:30 | 1969-07-20 20:17:20 | 1969-07-20 20:17:45 |
- 测试案例
SELECT TIMESTAMP1 as aaFROM T1WHERE TIMESTAMP1 BETWEEN TIMESTAMP2 AND TIMESTAMP3;
- 测试结果
| aa(TIMESTAMP) |
|---|
| 1969-07-20 20:17:30 |
本文转自实时计算——BETWEEN AND
