Sql Server IN Operator

SQL Server IN ( ) Operators

The SQL Server IN condition is used to avoid multiple OR conditions in a SELECT, INSERT, UPDATE, or DELETE statement.

Syntax

expression: It specifies a value to test.

value1, value2,.. value_n: It specifies the values to test against expression.

An SQL Server SELECT statement that uses the IN condition to compare string values:

  SELECT *  FROM [tutoraspire].[dbo].[Employees]  WHERE name IN (‘Mahesh’, ‘Lily’, ‘Rahul’);   

Output:

SQL Server in 1

  SELECT *  FROM [tutoraspire].[dbo].[Employees]  WHERE name = ‘Mahesh’  OR name = ‘Lily’  OR name = ‘Rahul’;  

Output:

SQL Server in 2

An SQL Server SELECT statement that uses the IN condition to compare numeric values:

  SELECT *  FROM [tutoraspire].[dbo].[Employees]  WHERE id IN (14, 13, 9, 11, 10);   

Output:

SQL Server in 3

  SELECT *  FROM [tutoraspire].[dbo].[Employees]  WHERE id = 14  OR id = 13  OR id = 9  OR id = 11  OR id = 10;   

Output:

SQL Server in 4

An SQL Server SELECT statement that uses the IN condition with NOT operator:

  SELECT *  FROM [tutoraspire].[dbo].[Employees]  WHERE name NOT IN (‘Mahesh’, ‘Lily’, ‘Rahul’);   

Output:

SQL Server in 5

  SELECT *  FROM [tutoraspire].[dbo].[Employees]  WHERE name <> ‘Mahesh’  AND  name <> ‘Lily’  AND name <> ‘Rahul’;  

Output:

SQL Server in 6