📌 Definition

The BETWEEN operator is used in a WHERE clause to filter records within a specified range of values.

👉 It selects values between two limits (inclusive).

🧠 Syntax

SELECT column_name
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

🔑 Important Concept

• BETWEEN includes both boundary values:

👉 Equivalent to:

column_name >= value1 AND column_name <= value2

📊 Example Table: Students

1. BETWEEN with Numbers

✅ Example

SELECT * FROM Students
WHERE Age BETWEEN 19 AND 21;

📌 Result

• Rahul (19)
• Karan (20)
• Riya (21)

💡 Explanation

Returns all students whose age is between 19 and 21 (inclusive).

2. BETWEEN with Strings

📌 Definition

BETWEEN can also be used with text (alphabetical range).

✅ Example

SELECT * FROM Students
WHERE Name BETWEEN 'A' AND 'M';

💡 Explanation

• Returns names starting from A to M.
• Works based on alphabetical (lexicographical) order.

3. BETWEEN with Dates

✅ Example

SELECT * FROM Orders
WHERE OrderDate BETWEEN '2024-01-01' AND '2024-12-31';

💡 Explanation

• Returns records within a date range.
• Very useful in real-world applications.

⚠️ Important Notes

1. Inclusive Nature

BETWEEN 10 AND 20

👉 Includes 10 and 20 both

2. Order Matters

BETWEEN 20 AND 10

👉 This will return no result (invalid range)

3. Use with NOT

You can exclude a range:

SELECT * FROM Students
WHERE Age NOT BETWEEN 19 AND 21;

👉 Returns values outside the range

🔄 Equivalent Form

SELECT * FROM Students
WHERE Age >= 19 AND Age <= 21;

👉 Same as:

WHERE Age BETWEEN 19 AND 21;

📊 Summary Table

🎯 Key Insight

The BETWEEN operator simplifies range conditions and makes queries:

• More readable
• Easier to write
• Less error-prone