SQL BETWEEN operator is basically used to select the values within a range. The values can be text, numbers, or dates. Here is the
general form of the BETWEEN operator in SQL:
SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;
SQL BETWEEN Operator Example
Here is an example of BETWEEN operator in SQL. Consider the following table CUSTOMERS having the records:
The following SQL statement selects all the columns of the table CUSTOMERS whose salary in between 76000 and 86000:
SELECT * FROM customers
WHERE salary BETWEEN 76000 AND 86000;
After querying the above SQL statements, you will get the following output:
SQL Online Test
« Previous Tutorial
Next Tutorial »
Latest 5 Posts by CodesCracker
