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 name of table 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