BETWEEN in SQL

BETWEEN in SQL

Introduction The BETWEEN operator is commonly used in SQL to specify a range of values in a query. It allows you to retrieve records within a specified range of values, including the boundaries.

Syntax The basic syntax of the BETWEEN operator is as follows:

sql
SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

Here, column_name is the name of the column on which the comparison is performed, table_name is the name of the table containing the column, value1 is the lower boundary value, and value2 is the upper boundary value.

Usage and Example Let's consider a scenario where you have a table named "employees" with columns such as "employee_id," "first_name," "last_name," and "salary." You want to retrieve all the employees whose salaries fall within a specific range.

sql
SELECT employee_id, first_name, last_name, salary
FROM employees
WHERE salary BETWEEN 50000 AND 70000;

In this example, the query selects the employee ID, first name, last name, and salary of all the employees whose salaries are between 50,000 and 70,000.

Note: The BETWEEN operator is inclusive, meaning that it includes the boundary values in the result set. If you want to exclude the boundary values, you can use the greater than (>) and less than (<) operators instead.

Conclusion The BETWEEN operator in SQL is a useful tool for retrieving records within a specified range of values. It allows you to filter data based on a column's value and provides flexibility in defining boundaries. By understanding the syntax and example usage of the BETWEEN operator, you can effectively utilize it in your SQL queries.