SELECT..FROM..WHERE..BETWEEN

SELECT <column-list> FROM <table-list> WHERE <conditions> BETWEEN <value1> AND <value2>

You can use BETWEEN operator to retrieve records that fall within a range. 

Table: Orders

OrderID	Customer	Employee	Order Date	ShippedVia	Freight	ShipCountry
10248	Wilman Kala	Buchanan, Steven	04-07-1996	Federal Shipping	32.38	France
10249	Hanari Carnes	Peacock, Margaret	08-07-1996	United Package	65.83	Brazil
10250	Hanari Carnes	Leverling, Janet	08-Jul-1996	United Package	58.17	Brazil
10251	Chop-suey Chinese	Buchanan, Steven	11-Jul-1996	United Package	22.98	Switzerland
10252	Richter Supermarkt	Dodsworth, Anne	12-Jul-1996	Federal Shipping	148.33	Switzerland

The following SQL statement will return results from the Orders table that have Freight value between 30 and 60. The returned results are shown in ResultSet1.

SELECT * FROM Orders WHERE Freight BETWEEN 30 AND 60

Resultset1

OrderID	Customer	Employee	Order Date	ShippedVia	Freight	ShipCountry
10248	Wilman Kala	Buchanan, Steven	04-07-1996	Federal Shipping	32.38	France
10250	Hanari Carnes	Leverling, Janet	08-Jul-1996	United Package	58.17	Brazil
10251	Chop-suey Chinese	Buchanan, Steven	11-Jul-1996	United Package	22.98	Switzerland

.