notBetween/NOTBETWEEN

select col(s)
from table
where col notBetween value1 and value2

col(s) is column name(s) to select. It can be one or more column names or * (indicating all columns).

table is the table name to query.

col is the column to be filtered.

value1, value2 is any valid expression.value1 indicates the starting value, and value2 indicates the ending value. value1, value2 and col must have the same data type.

Query records where the price column values are not between 2 and 4:

timeCols = 2024.11.14+1..6
symCols = `APPL`AMZN`IBM`IBM`AAPL`AMZN
priceCols = 1.8 2.3 3.7 3.1 4.2 2.8

t = table(timeCols as time, symCols as sym, priceCols as price);
select * from t where price notBetween 2 and 4

// equivalent to select * from t where price notBetween 2:4
// equivalent to select * from t where price not between 2 and 4

Query all records where the date in the time column is not between 2024.11.16 and 2024.11.18.

select * from t where time notBetween 2024.11.16 and 2024.11.18