SQL SELECT IN

SQL SELECT IN operator allows to test if an expression matches any values in a list of values. This is generally used to reduce the use of multiple OR conditions in a SELECT, INSERT, UPDATE and DELETE statement.

SQL SELECT IN Syntax

The syntax of SQL SELECT IN is as follows.

expression IN (value1, value2, ....,valueN);

or 

expression IN (subquery);

In this syntax,

• expression – The value to be test. 
• value1, value2,…,valueN – These are the values to test against expression. If any of these values matches expression, then the IN condition will evaluate to true.
• subquery – This is a SELECT statement whose result set will be tested against expression. If any of these values matches expression, then the IN condition will evaluate to true.

SQL SELECT IN Example

Let’s consider the below Employee table for our reference and example.

Now let’s take an example of IN operator which use the above table.

SELECT * FROM Employee
WHERE emp_id IN (1510,1511,1513,1514)
ORDER BY emp_id;

Let’s check another example where character values are supplied in the IN operator.

SELECT * FROM Employee
WHERE emp_location IN ('Mumbai', 'Delhi')
ORDER BY emp_id;

Output of the the above query is as below.

Summary: In this tutorial, you have learned how to use IN operator in SQL with syntax and examples.