Using BETWEEN clause to specify range of values in SQL Query

In SQL Server 2014 , you can use the BETWEEN clause to specify a range of values in the search criteria.

How to specify a range of values in a Query in SQL Server ?

For example , you want to to query the Employee table to display the employees having the birthdate between 1969-01-29 and 1975-12-01′ , you can use the BETWEEN clause as shown  in the example.

use AdventureWorks2014
GO
SELECT * FROM HumanResources.Employee
where BirthDate BETWEEN '1969-01-29' AND '1975-12-01'