Purpose: The IN clause allows you to specify multiple values in a WHERE clause, checking if a column’s value matches any value in a list or subquery.Syntax:
WHERE column_name IN (value1, value2, ...);
Example:
SELECT * FROM employees WHERE department_id IN (10, 20);
Explanation: This retrieves employees from departments 10 or 20, making it easier than using multiple OR conditions.
Leave a Reply