SQL Keyword - IN

IN Keyword

The IN keyword is used to check multiple values in a where clause.

When you want to give a condition based on multiple values, then the In Operator is used.

The IN operators behave the same as the OR operators.

Syntax

SELECT <COLUMNS> FROM <TABLE_NAME>
WHERE <COLUMN_NAME> IN (<VALUE1>,<VALUE2>,<VALUE3>);

Example

SELECT * FROM Employee
WHERE Emp_Dept IN ('IT', 'Finance', 'Purchase');

Summary

In a where clause, the IN keyword is utilised to check multiple values.

Next Recommended Reading SQL Keyword - ALL