The BETWEEN predicate can be used to determine if a value is within a specified value range or not. The first expression specifies the lower bound of the range and the second expression specifies the upper bound of the range. This predicate can be used inside of a WHERE, HAVING, or JOIN statement.
The predicate evaluates to true if the value is greater than or equal to the lower bound of the range, or less than or equal to the upper bound of the range.
expr [ NOT ] BETWEEN expr AND expr
salary BETWEEN 2000.00 AND 10000.00