Between AND « Select Query « SQL Server / T-SQL

1.BETWEEN operator specifies a range: determines the lower and upper bounds of qualifying values
2.Use 'Between ... and' operator on a date data type
3.'Between and' for a number data type
4.Not 'Between...and'
5.BETWEEN operator is equal to two individual comparisons, which are connected with the Boolean operator AND