SQL Condition - IN and NOT IN

Using IN Statement in WHERE Clause, we can select a subset of rows from the Table which satisfy the values present in the IN Clause.
Using NOT IN statement in WHERE Clause, we can select a subset of rows from the Table which satisfy the values not present in the IN Clause. Let us see examples to make this clear.

Imagine we have table called CUSTOMERS, with the following data:

Rambo

Robert

Belgium

Mugambo

Satraj

Norway

Nagashekar

Rao

India

Tom

Harry

Brazil

Dana

Laura

Australia

Rambo

Fox

New Zealand

Giselle

Chivvi

Japan

Scenario 1: Get me all records where Customer's Country is in Belgium or India or Brazil. We can use a IN Clause to specify the above criteria.

SELECT * from Customer WHERE COUNTRY IN ('Belgium', 'India', 'Brazil')

Result:

Rambo

Robert

Belgium

Nagashekar

Rao

India

Tom

Harry

Brazil

In the above WHERE Clause, we used IN Condition to specify filter on only the countries Belgium, India and Brazil.

Scenario 2: Get me all records where Customer's Country is NOT in Belgium, India and Brazil. We can use a NOT IN Clause to specify the above criteria.

SELECT * from Customer WHERE COUNTRY NOT IN ('Belgium', 'India', 'Brazil')

Result:

Mugambo

Satraj

Norway

Dana

Laura

Australia

Rambo

Fox

New Zealand

Giselle

Chivvi

Japan

In the above WHERE Clause, we used NOT IN Condition to specify filter out the countries Belgium, India and Brazil.