Using BETWEEN clause to specify range of values in SQL Query

Published on August 17, 2016 by abundantcode

Filed under SQL Server

Last modified August 17, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 3619 times

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'

image

Leave a Comment


x

You might be Interested in these Posts

C Program to find the G.C.D of a number using Recursive function

Problem Write a program in C to find the find the G.C.D of a number using recursion and display the ...

C Program to print a Half Pyramid using *

Problem Write a program in C to print Half pyramid using * as shown. * * * * * * * * * * ...

C Program to display Positive factors of a number

Problem Write a program in C to display all the positive factors of a number enter by the user. Ho...