between

New in version 2.00.9.

between…and 用于匹配指定范围内的所有值，包括起始值和终止值，其功能等同于 between 函数。

$ select col(s)
$ from table
$ where col [not] between value1 and value2

例子

$ t = table(`APPL`AMZN`IBM`IBM`AAPL`AMZN as sym, 1.8 2.3 3.7 3.1 4.2 2.8 as price);
$ select * from t where price between 2 and 4
// 等价于 select * from t where price between 2:4

sym	price
AMZN	2.3
IBM	3.7
IBM	3.1
AMZN	2.8

$ select * from t where sym between `A and `H

sym	price
APPL	1.8
AMZN	2.3
APPL	4.2
AMZN	2.8