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






  1. SQL Server / T-SQL
  2. Select Query
  3. Between AND
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