SQL — Between

Basic BETWEEN

SELECT * FROM employees
WHERE salary BETWEEN 40000 AND 60000;

NOT BETWEEN

SELECT * FROM employees
WHERE salary NOT BETWEEN 40000 AND 60000;

Dates

SELECT * FROM orders
WHERE order_date BETWEEN '2026-01-01' AND '2026-12-31';

Text

SELECT * FROM users
WHERE name BETWEEN 'A' AND 'M';

Mini Practice

Write SQL code that:

1. Uses BETWEEN for numeric ranges
2. Uses BETWEEN for date ranges
3. Uses NOT BETWEEN
4. Combines BETWEEN with other conditions

Up Next

In the next lesson, you'll learn about Union — combining query results.