IN, NOT IN, BETWEEN, LIKE

Understanding IN, NOT IN, BETWEEN, and LIKE

These operators help make your WHERE clause more powerful and expressive.

1. IN and NOT IN

SELECT * FROM employees WHERE department_id IN (10, 20, 30);
SELECT * FROM employees WHERE department_id NOT IN (40, 50);

2. BETWEEN

SELECT * FROM employees WHERE hire_date BETWEEN '01-JAN-2020' AND '31-DEC-2020';

3. LIKE

SELECT * FROM employees WHERE first_name LIKE 'A%';