The SQL BETWEEN Operator
The SQL BETWEEN operator is used to filter rows based on a range of values within a specified column. It allows you to retrieve rows where a column’s value falls within a specified range of values, inclusive of both endpoints.
Let’s take a look at the SQL BETWEEN operator below
Examples of sql BETWEEN Operator
Example 1: Using BETWEEN with Numeric Values
SQL> SELECT * FROM Employees
WHERE Salary BETWEEN 40000 AND 60000;
Salary BETWEEN 40000 AND 60000 checks whether the “Salary” column value falls within the specified range.
Example 2: Using BETWEEN with Date Values
SQL> SELECT * FROM Orders
WHERE OrderDate BETWEEN ‘2023-01-01’ AND ‘2023-02-28’;
OrderDate BETWEEN ‘2023-01-01’ AND ‘2023-02-28’ checks whether the “OrderDate” falls within the specified date range.
Example 3: Using NOT BETWEEN
SQL> SELECT * FROM Products
WHERE Price NOT BETWEEN 30 AND 50;
Price NOT BETWEEN 30 AND 50 retrieves rows where the “Price” column value is not within the specified range.
Example 4: Using BETWEEN with Strings
SQL> SELECT * FROM Products
WHERE ProductName BETWEEN ‘A’ AND ‘G’;
ProductName BETWEEN ‘A’ AND ‘G’ checks whether the “ProductName” falls within the specified string range.
Whether the data being filtered and retrieved is made up of numeric, date, or string values, the SQL BETWEEN operator is a flexible tool.
It makes it simple for you to run conditional queries against your database using ranges of variables.