SQL BETWEEN

What is BETWEEN?

BETWEEN is used to filter values within a range.

It includes both the starting and ending values.

Basic Syntax

SELECT *
FROM table_name
WHERE column BETWEEN value1 AND value2;

Example

SELECT *
FROM employees
WHERE salary BETWEEN 40000 AND 60000;

BETWEEN with Dates

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

BETWEEN with Text

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

NOT BETWEEN

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

Using with AND Conditions

SELECT *
FROM employees
WHERE salary BETWEEN 40000 AND 60000
AND department = 'Sales';

Full Example

SELECT name, salary
FROM employees
WHERE salary BETWEEN 40000 AND 60000;

Why BETWEEN is Important

• Simplifies range queries
• Improves readability
• Common in filtering data

Common Mistakes

• Forgetting it is inclusive
• Using incorrect data types
• Reversing start and end values

Practice

Filter rows using a range condition.

SELECT *
FROM table_name
WHERE column BETWEEN value1 AND value2;

Need Help?

Ask the AI if you need help understanding or want to dive deeper in any topic