|
|
|
|
|
|
Syntax
column-expression [ NOT ] IN ( list-expression )
Semantics
column-expression |
is a single column of one the tables specified in the FROM clause. |
list-expression |
is a comma-separated list of constant values matching the data type of the column-expression |
Examples
x IN (5, 6, 7) |
|
x in (select a from table) |
not allowed |
(x, y) in ((5,6), (7,8)) |
not allowed |