BETWEEN operator is used to retrieve rows from a database table based on a range of values. It allows you to specify a lower and an upper limit, and the operator selects all rows whose values fall within that range, including the limits themselves.
Here’s the general syntax for using the
BETWEEN operator in an SQL query:
SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2;
Let’s break down the syntax:
SELECT: Specifies the columns you want to retrieve.
FROM: Specifies the table from which you want to retrieve the data.
WHERE: Specifies the condition that must be met for the rows to be selected.
column_name: The name of the column you want to compare.
value2: The lower and upper limits, respectively, of the range you want to specify.
Here’s an example that demonstrates the usage of the
BETWEEN operator. Let’s say we have a table called
employees with columns
salary. We want to retrieve all employees whose salaries fall between $3000 and $5000:
SELECT employee_id, first_name, salary FROM employees WHERE salary BETWEEN 3000 AND 5000;
This query will return all rows from the
employees table where the
salary column value is between $3000 and $5000 (inclusive).
It’s important to note that the
BETWEEN operator is inclusive of the limits, which means rows with values equal to
value2 will be included in the result. If you want to exclude one of the limits, you can use the
> (greater than) or
< (less than) operators instead.