Not in list
Returns true when the left operand does not match any element in the right-hand list or array.
Category: comparison
SQL symbol: NOT IN
Syntax
sql
<value> NOT IN (<item> [, ...])
<value> NOT IN <array>Parameters
<value>— The value to look for. Acceptsboolean,date,decimal,float,integer,nvarchar,timestamp,varbinary,varchar.<list>— The values to look in. Every element must share one type; a mixed list is rejected at plan time. Acceptsarray.
Returns
Examples
sql
SELECT name FROM $planets WHERE name NOT IN ('Earth', 'Mars') LIMIT 3;Mercury
Venus
Jupiter
Signatures
boolean NOT IN array→ booleandate NOT IN array→ booleandecimal NOT IN array→ booleanfloat NOT IN array→ booleaninteger NOT IN array→ booleannvarchar NOT IN array→ booleantimestamp NOT IN array→ booleanvarbinary NOT IN array→ booleanvarchar NOT IN array→ boolean
Notes
Like !=, a row whose value is NULL answers NULL rather than true, so it does not survive a WHERE clause.