IN

IN is a SQL clause in the SELECT Queries category. Checks if a value matches any value in a list (shorthand for multiple OR conditions). The syntax is SELECT * FROM table WHERE column IN (value1, value2, ...);. It returns matching rows. A typical example: SELECT * FROM employees WHERE department IN ('IT', 'HR', 'Finance'); -- Employees in IT, HR, or Finance departments A close relative is SELECT, which retrieves data from a table. The most fundamental SQL statement. A close relative is SELECT *, which selects all columns from a table. A close relative is SELECT DISTINCT, which returns only distinct (unique) values from the specified columns. More about this category: Core SELECT query clauses — SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT. Related SELECT Queries entries: SELECT, SELECT *, SELECT DISTINCT, WHERE, AND / OR / NOT, BETWEEN, LIKE, IS NULL / IS NOT NULL.