SQL IN

In this tutorial, we will learn how to use IN operator with WHERE clause.

SQL IN Operator

SQL IN operator is used to filtering the result set based on the list of discrete/distinct values.

SQL IN operator is always used with the WHERE clause.

SQL IN operator is a shorthand for multiple OR conditions.

SELECT column1, column2,...columnN
FROM tableName
WHERE column IN (value1, value2,...valueN);

SELECT column1, column2,...columnN
FROM tableName
WHERE column IN (SELECT STATEMENT);

Example:

Let us consider this table "Employee" for records.

Table Name: Employee

Example of IN Operator

Select all the employee whose city is "Delhi", "Noida" or "New York", a query will be:

SELECT * FROM Employee
WHERE City IN ('Delhi', 'Noida', 'Newyork');

Select all the employee whose city is not "Delhi", Noida" or "New York", a query will be:

SELECT * FROM Employee
WHERE City NOT IN ('Delhi', 'Noida', 'Newyork');

Example IN Operator using subquery or SELECT statement 

Select all the employee whose city is "Delhi", "Noida" using select statement, a query will be:

SELECT * FROM Employee
WHERE City IN (SELECT City FROM Employee WHERE City='Noida' or City='Delhi');