SQL IN Operator
SQL IN Operator
In SQL, the IN operator is used to specify multiple values in a WHERE clause. The IN operator allows you to specify a list of values to be used in a WHERE clause, instead of writing out multiple OR conditions.
Here’s the syntax for using the IN operator:
SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);
In the WHERE clause, you can specify a list of values within parentheses, separated by commas. The values can be of any data type, as long as they match the data type of the column you’re querying.
Here’s an example:
SELECT * FROM employees
WHERE department IN ('Sales', 'Marketing', 'Engineering');
This query will return all employees who work in the Sales, Marketing, or Engineering departments.
You can also use a subquery with the IN operator to select values from another table. Here’s an example:
SELECT * FROM employees
WHERE department IN (SELECT department_name FROM departments WHERE location = 'New York');
This query will return all employees who work in departments located in New York.
The IN operator is useful when you need to specify multiple values in a WHERE clause, and can help simplify your queries by avoiding the need for multiple OR conditions.