Between

In SQL Server, with the help of "Between" logical operator, we can provide the value range to test expression for evaluation.

Syntax:-

test_expression [ NOT ] BETWEEN <start value/expression> AND <end value/expression>

Note:- BETWEEN consider the range inclusive of start and end value for evaluation of test expression.

Example:-
Create a table and insert some records in table as below:-

Now let's make use of "Between" in our query:-