in

The in operator is used to specify one or more values in a where clause. The in operator is a shorthand for multiple or conditions.

Syntax

select col(s)
from table
where col [not] in (value1, value2, ...)

or

select col(s)
from table
where col [not] in (subquery)

Arguments

col(s) is column name(s) to be selected.

table is the table name to be queried.

col is the column to be filtered.

value1, value2, .../subquery is the value(s) to be filtered.

Examples

t = table(`APPL`AMZN`IBM`IBM`APPL`AMZN as sym, 1.8 2.3 3.7 3.1 4.2 2.8 as price);
select * from t where sym in (`APPL, `AMZN)
    // select * from t where sym=`APPL or sym=`AMZN
sym price
APPL 1.8
AMZN 2.3
APPL 4.2
AMZN 2.8
t1=table(`APPL`AMZN`IBM`IBM`APPL`AMZN as sym, 200 500 300 350 240 580 as vol);
select * from t where sym in (select sym from t1 where sym=`IBM)
sym price
IBM 3.7
IBM 3.1