VeloDB Cloud 26.x·Apache Doris 4.x (≤ 4.0 supported)·"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
| Operator | Function | Example |
|---|---|---|
| IN | Tests if it is equal to any member. Returns TRUE if so. | SELECT 1 IN (SELECT 2) |
| NOT IN | Tests if it is not equal to all members. Returns TRUE if so. | SELECT 1 NOT IN (3, 4, 5) |