MS Sql Server Tutorials | Examples | Interview Questions Tutorial

MS SQL Server IN Operator

❮ Previous Next ❯

IN is used to replace or avoid multiple arguments combined with an OR in for SELECT, UPDATE or DELETE Statements.
Syntax:

Expression IN(value1, value2,....value_n);

Example:

SELECT * FROM [University].[dbo].[Student] WHERE Name IN('Ravi','Savi');

SELECT * FROM [University].[dbo].[Student] WHERE Name='Ravi' OR Name='Savi';

Example:

SELECT * FROM [University].[dbo].[Student] WHERE Age IN(18,19,20);

SELECT * FROM [University].[dbo].[Student] WHERE Age=18 OR Age=19 OR Age=20);

Example:

SELECT * FROM [University].[dbo].[Student] WHERE Name NOT IN('Ravi','Savi');

SELECT * FROM [University].[dbo].[Student] WHERE Name<>'Ravi' AND Name<>'Savi';

❮ Previous Next ❯