Structured Query Language (SQL) has a multitude of operators that allow for flexible queries. These ensure that the most accurate results are obtained.
BETWEEN operator allows for the selection of values in a given range. For example, suppose you want data on your teenage customers. To do this, you could easily run an SQL query that uses the
BETWEEN operator to fetch only those records in which the age lies between 13 and 19.
BETWEEN is inclusive, which means that the beginning and end values are also included in the range.
SELECT columnName FROM tableName WHERE columnName BETWEEN a AND b;
The beginning and end values can be numbers, text, or dates. Let’s look at an example.
Run the code below to get products that have a price between 10 and 12 dollars.
CREATE TABLE Inventory ( p_ID int, p_name varchar(255), p_price int, s_ID int, p_number int ); INSERT INTO Inventory VALUES (1,'Apple',12,1,120); INSERT INTO Inventory VALUES (2,'Orange',10,1,105); INSERT INTO Inventory VALUES (3,'Banana',8,2,90); INSERT INTO Inventory VALUES (4,'Mango',15,3,95); INSERT INTO Inventory VALUES (5,'Peach',14,1,115); SELECT * FROM Inventory WHERE p_price BETWEEN 10 AND 12;
View all Courses