How to filter by a set or a range in SQL — IN / BETWEEN

You want rows belonging to a short list of departments with salaries inside a range.

Every example runs against the cheatsheet's sample tables — departments(id, name), employees(id, name, dept_id, salary, manager_id, hired_on) and orders(id, emp_id, amount, ordered_on) — and was executed and verified against SQLite, so you can paste it in and get the same result.

SELECT name, salary FROM employees
WHERE dept_id IN (1, 2) AND salary BETWEEN 70000 AND 100000
ORDER BY salary DESC;
-- Bob 95000 / Carol 88000 / David 72000 (BETWEEN includes both endpoints)

SQL Cheatsheet one-page card — queries that actually work — The full one-page card — SQL Cheatsheet. Get the complete cheatsheet on GitHub