SQL Server Transact Basic to Expert - Select Query With Between clause

This blog shows on to use the Between Clause with the select and where clause to fetch some data within some time duration or date duration.

Syntax

Select column_list
From table
Where column1 between 'Date1' And 'Date2'


Example:

Select EmpName, EmpDateofJoining
From Emptable
Where EmpDateofJoining between '1/1/2010' AND '1/1/2011'