SQL Server Transact Basic to Expert - Select Query With IN Clause in Where condition

This blog shows how to use  a list of values as a condition in a single column with the where clause using IN operator

Syntax:

Select Column_list
From table
Where Column1 IN ('Value1', 'Value2', 'Value3')

Example

Select EmpName, EMpSal
From EmpSal
Where EmpID IN ('1','2','3')