SQL WHERE BETWEEN

List all orders between $1000 and $2000.

SELECT OrderDate, OrderNumber, TotalAmount
  FROM [Order]
 WHERE TotalAmount BETWEEN 1000 AND 2000

OrderDate	OrderNumber	TotalAmount
2012-07-05 00:00:00.000	542379	1863.40
2012-07-08 00:00:00.000	542380	1813.00
2012-07-10 00:00:00.000	542383	1444.80
2012-07-16 00:00:00.000	542387	1119.90
2012-07-19 00:00:00.000	542390	1746.20

WHERE BETWEEN syntax.

SELECT column-names
  FROM table-name
 WHERE column-name BETWEEN value1 AND value2

SELECT Id, ProductName, UnitPrice
  FROM Product
 WHERE UnitPrice BETWEEN 10 AND 20
 ORDER BY UnitPrice

Id	ProductName	UnitPrice
3	Aniseed Syrup	10.00
21	Sir Rodney's Scones	10.00
74	Longlife Tofu	10.00
46	Spegesild	12.00
31	Gorgonzola Telino	12.50

SELECT Id, ProductName, UnitPrice
  FROM Product
 WHERE UnitPrice NOT BETWEEN 5 AND 100
 ORDER BY UnitPrice

SELECT COUNT(Id) AS Count, 
       SUM(TotalAmount) AS 'Total Sales'
  FROM [Order]
 WHERE OrderDate BETWEEN '1/1/2013' AND '1/31/2013'

COUNT and SUM are built-in aggregate functions.

• Our Sql COUNT Function Reference
• Our Sql SUM Function Reference
• Our Sql WHERE IN Reference