What is BETWEEN operator in SQL Server?

The BETWEEN operator is used to view data between two values.

Ex :
Select * from Employees
where Joiningdate
between ’06-Jan-2006’ and ’15-July-2007’

This Query will display all the records of employees joined between 06-Jan-2006 and 15-July-2007.