Skip to main content
VeloDB Cloud 4.x·Apache Doris 3.x·"Since X.Y" tags refer to Doris versionsversion mapping →

In Operators

Description​

The IN operator tests whether a value is a member of a list of values or a subquery.

Operator Introduction​

OperatorFunctionExample
INTests if it is equal to any member. Returns TRUE if so.SELECT 1 IN (SELECT 2)
NOT INTests if it is not equal to all members. Returns TRUE if so.SELECT 1 NOT IN (3, 4, 5)