SQL BETWEEN

SQL BETWEEN is used as follows.

SQL BETWEEN Syntax

SELECT <column_list> FROM <table_name> WHERE <column_name> BETWEEN <lower_value> AND <higher_value>

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:

Table: BRANCH

branch_nbr	branch_name	region_nbr	employee_count
108	New York	100	10
110	Boston	100	6
212	Chicago	200	5
404	San Diego	400	6
415	San Jose	400	3

This SQL Statement with BETWEEN is executed:

SELECT branch_nbr, branch_name, employee_count FROM branch WHERE employee_count BETWEEN 4 AND 7

Here is the result.

branch_nbr	branch_name	employee_count
110	Boston	6
212	Chicago	5
404	San Diego	6