SQL – Between Operator
Table Of Contents:
- What Is SQL Between Operator?
- Syntax Of SQL Between Operator.
- Examples Of SQL Between Operator.
(1) What Is SQL Between Operator?
The
BETWEEN
operator selects values within a given range.The values can be numbers, text, or dates.
The
BETWEEN
operator is inclusive: begin and end values are included.
(2) Syntax Of SQL Between Operator?
Syntax:
SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;
(3) Examples Of SQL Between Operator?
Demo Data:
Example-1: Between Example
SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20;
Example-2: Not Between Example
SELECT * FROM Products
WHERE Price NOT BETWEEN 10 AND 20;
Example-3: BETWEEN with IN Example
SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20
AND CategoryID NOT IN (1,2,3);
Example-4: BETWEEN Text Values Example
SELECT * FROM Products
WHERE ProductName BETWEEN 'Carnarvon Tigers' AND 'Mozzarella di Giovanni'
ORDER BY ProductName;
Example-5: Not BETWEEN Text Values Example
SELECT * FROM Products
WHERE ProductName NOT BETWEEN 'Carnarvon Tigers' AND 'Mozzarella di Giovanni'
ORDER BY ProductName;
Example-6: BETWEEN Dates Example
SELECT * FROM Orders
WHERE OrderDate BETWEEN '1996-07-01' AND '1996-07-31';