Used alongside a WHERE clause as a shorthand for multiple OR conditions.
So instead of:
SELECT * FROM users
WHERE country = 'USA' OR country = 'United Kingdom' OR
country = 'Russia' OR country = 'Australia';
You can use:
SELECT * FROM users
WHERE country IN ('USA', 'United Kingdom', 'Russia',
'Australia');
(IN) operator in sql like "OR" operator
For example:
Select * From employees
Where department_id "IN" (60,90);
SELECT first_name, country
FROM Customers
WHERE country IN ('USA', 'UK');
SELECT FullName
FROM EmployeeDetails
WHERE FullName LIKE ‘__hn%’;
SELECT EmpId,
Salary+Variable as TotalSalary
FROM EmployeeSalary;
SELECT EmpId FROM EmployeeDetails
UNION
SELECT EmpId FROM EmployeeSalary;
(IN) operator in sql like "OR" operator
For example:
Select * From employees
Where department_id "IN" (60,90);