The IN operator is used to compare a column with one or more value. It is similar to
OR condition.
Example :
Select EmployeeName, EmployeeIDfrom Employeeswhere City in (‘Chennai’,
‘Bangalore’)
This Query will display the Employee Name, Employee ID only from city “Chennai”
and “Bangalore”.