Ascending
SELECT * FROM regtable
ORDER BY Country;
Descending
SELECT * FROM Customers
ORDER BY Country DESC;
Order by Several Columns
SELECT * FROM Customers
ORDER BY Country, CustomerName;
Order by Several Columns Asc and Desc
SELECT * FROM Customers
ORDER BY Country ASC, CustomerName DESC;