Range Queries with BETWEEN

BETWEEN filters values within a range (inclusive).

SELECT * FROM employees
WHERE salary BETWEEN 70000 AND 90000;

This is the same as:

WHERE salary >= 70000 AND salary <= 90000

BETWEEN works with:

• Numbers
• Dates
• Text (alphabetically)

Both endpoints are included!