devxlogo

Between Statement

Between Statement

Question:
How do I write a statement that selects data between two dates?

Answer:
You can select data within two dates using the BETWEEN operator. Using the Orders table in the Northwind database, here’s a sample query:

SELECT OrderID, CustomerID, OrderDateFROM Northwind.dbo.OrdersWHERE OrderDate BETWEEN '7/1/96' AND '7/31/96'

The BETWEEN operator includes records where the criteria matches the BETWEEN values. So records with dates of 7/1/96 and 7/31/96 will be included. You can also use NOT BETWEEN to exclude data, like this:

SELECT OrderID, CustomerID, OrderDateFROM Northwind.dbo.OrdersWHERE OrderDate BETWEEN '7/1/96' AND '7/31/96'

devx-admin

Share the Post: