Loading

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

Karthikeyan Anbarasan

Comments

Join the conversation! Your thoughts help the community grow.

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')