Using BETWEEN clause to specify range of values in SQL Query


This content was proof-read by Grammarly. You can Try Grammary for FREE

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.


Are you a .NET Developer planning to integrate GraphQL for .NET in your Application? Check out this book BUY & DOWNLOAD GRAPHQL.NET COOKBOOK
use AdventureWorks2014
GO
SELECT * FROM HumanResources.Employee
where BirthDate BETWEEN '1969-01-29' AND '1975-12-01'
How to specify a range of values in a Query in SQL Server ?
%d bloggers like this: