Text copied!
BETWEEN operator
In SQL, Operators are special character, symbol or a keyword that is used to perform some specific operations. For example : comparing data
SQL operators are commonly used with SQL statements to retrieve, filter, and manipulate data.
BETWEEN operator :
BETWEEN operator is used to retrieve rows that exists within/between a specified range. It is used in 'WHERE' clause to filter and retrieve specific data.
The syntax of the BETWEEN operator generally looks like this :
SELECT column_name(s)
FROM table_name
WHERE column BETWEEN value1 AND value2;
• Specify the column(s) name after the 'SELECT' keyword.
• Specify Asterisk (*) symbol to selects all columns from the table after the 'SELECT' keyword.
• Specify the table name after the 'FROM' keyword.
• Specify the conditions after the 'WHERE' keyword.
• Specify the lower and upper value after the 'BETWEEN' keyword.
Here's an example of how you might use the BETWEEN operator :
1. Let's assume we have a table named "[Employees]".
Let's assume you want to retrieve employee data from [Employees] table where employee's Salary is in between '2000' and '4000'.
Run below SQL statement :
SELECT *
FROM [Employees]
WHERE Salary BETWEEN 2000 AND 4000;
Above statement will retrieve employee data where employee's Salary is greater than equal to '2000' and less than equal to '4000'.
