SELECT <column-list> FROM <table-list> ORDER BY <column-list>

The records returned from the SELECT command can be sorted by the values in one or more columns.

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-07-1996	United Package	58.17	Brazil
10251	Chop-suey Chinese	Buchanan, Steven	11-07-1996	United Package	22.98	Switzerland
10252	Richter Supermarkt	Dodsworth, Anne	12-07-1996	Federal Express	148.33	Switzerland

SELECT Customer, Employee, Freight, ShipCountry ORDER BY ShipCountry

The above SQL statement will sort records in Orders table by ShipCountry column as shown in Resultset1.

Resultset1

Customer	Employee	Freight	ShipCountry
Hanari Carnes	Peacock, Margaret	65.83	Brazil
Hanari Carnes	Leverling, Janet	58.17	Brazil
Wilman Kala	Buchanan, Steven	32.38	France
Chop-suey Chinese	Buchanan, Steven	22.98	Switzerland
Richter Supermarkt	Dodsworth, Anne