Skip to content

SQL NOT IN

The NOT IN operator checks a value within a set of values, and retrieve the rows from the table which are NOT matching. This is opposite of SQL IN operator.

SQL NOT IN Syntax

[Expression] NOT IN (value1,value2,value3…..);

Example:
Get the list from the Books table where the AUTHORSLASTNAME is not  ‘kalka’ ,  ‘MEYER’ ,  ‘AUSTEN’.

Query:
SELECT TITLE,AUTHORFIRSTNAME,AUTHORLASTNAME FROM BOOKS
WHERE AUTHORLASTNAME NOT IN (‘kalka’,’MEYER’,’AUSTEN’);

Output

TITLEAUTHORFIRSTNAMEAUTHORLASTNAME
Animal FarmGeorgeOrwell
MadhushalaGirishKarnad
HistoricaHerodotusHerodotus
MOON CALLEDPATRICIABRIGS

Published inSQL