What is SQL BETWEEN?
The SQL BETWEEN operator enables a comparison to a range of values.
Why Use SQL BETWEEN?
The SQL IN operator is a clean way to check for inclusion in a range without requiring an AND operator.
How To Use SQL BETWEEN
SQL BETWEEN is used as follows.
SQL BETWEEN Syntax
SQL BETWEEN Example
The following example lists rows in the branch that have employee_count in range from 4 to 7.
Here are the contents of the table:
This SQL Statement with BETWEEN is executed:
Here is the result.