NOT IN condition in PostgreSQL

PostgreSQL NOT IN To filter the results, the PostgreSQL NOT IN condition is used with SELECT, INSERT, UPDATE and DELETE statements to negate the IN conditions.

Syntax:

WHERE expressions NOT IN (value1, value2, .... value_n);  

Parameters: expressions: It is used to specify a column or a field. value_1, value_2… value_n: They are used to specify the values to be tested against the expressions.

Example: Students table:

Query:

SELECT *  
FROM “STUDENTS”  
WHERE “NAME” NOT IN (‘Joy’, 'Happy', 'Smiley');

Output:

Please follow and like us: