SQL IN Keyword
The IN operator is used in a WHERE clause to help filter rows based on whether a column’s value matches any value from a list. It works like a cleaner version of using multiple OR conditions.
SQL IN Syntax
SELECT column1, column2, ... FROM table_name WHERE column_name IN (value1, value2, ...);
You can also use it with a subquery:
SELECT column1, column2, ... FROM table_name WHERE column_name IN (SELECT column_name FROM other_table);
SQL IN Matching Multiple Values Example
SELECT *
FROM Patients
WHERE gender IN ('M', 'F');
SQL IN Excluding Values Using NOT IN Example
SELECT *
FROM Patients
WHERE gender NOT IN ('M');
SQL IN Using A Subquery Example
SELECT *
FROM Prescriptions
WHERE appointment_id IN (
SELECT appointment_id
FROM Appointments
);
SQL IN Labs
