Sorting Multiple Columns in SQL

SELECT * FROM customers

ORDER BY CustomerName, ContactName;

In this usage, if you have some results that has the same CustomerName, these  results will be ordered by the ContactName .

That’s the logic of this syntax.

http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all