语法
入参
功能描述
BETWEEN操作符用于选取介于两个值之间的数据范围内的值。
示例一
| int1(INT) |
int2(INT) |
int3(INT) |
| 90 |
80 |
100 |
| 11 |
10 |
7 |
SELECT int1 as aaFROM T1WHERE int1 BETWEEN int2 AND int3;
示例二
| var1(varchar) |
var1(varchar) |
var1(varchar) |
| b |
a |
c |
SELECT var1 as aaFROM T1WHERE var1 BETWEEN var2 AND var3;
示例三
| 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
