SQL - IN & NOT IN CLAUSE

SQL IN CLAUSE | SQL NOT IN | PRACTICE YOURSELF

SQL IN operator is used to allow multiple value in a WHERE clause condition. It is similar to having MULTIPLE OR conditions

SQL IN CLAUSE

SYNTAX

EXAMPLE

Let’s fetch all the data from Persons table in our Demo Database where city is Bangalore or Pune:

​

SELECT * FROM PERSONS;

SQL NOT IN operator is used to exclude multiple value in a WHERE clause condition. It is similar to a NOT condition.

SQL NOT IN

SYNTAX

EXAMPLE

Let’s fetch all the data from Persons table in our Demo Database where city is not Bangalore or Pune:

SELECT * FROM PERSONS;