SQL BETWEEN Operator
SQL BETWEEN Operator
In SQL, the BETWEEN operator is used to select values within a range. The BETWEEN operator is inclusive, meaning it includes both the start and end values in the range.
Here’s the syntax for using the BETWEEN operator:
SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;
In the WHERE clause, you can specify the range of values using the BETWEEN operator, followed by the start and end values separated by the AND keyword. The values can be of any data type, as long as they match the data type of the column you’re querying.
Here’s an example:
SELECT * FROM employees
WHERE salary BETWEEN 50000 AND 75000;
This query will return all employees whose salary is between $50,000 and $75,000.
You can also use the NOT keyword with the BETWEEN operator to select values outside of a range. Here’s an example:
SELECT * FROM employees
WHERE salary NOT BETWEEN 50000 AND 75000;
This query will return all employees whose salary is not between $50,000 and $75,000.
The BETWEEN operator is useful when you need to select values within a specific range, and can help simplify your queries by avoiding the need for multiple conditions.