按多列排序 - Code Recipes

数据排序

SELECT Continent, Region, Name
FROM country
ORDER BY Continent, Region, Name

Continent	Region	Name
Asia	Eastern Asia	China
Asia	Eastern Asia	Hong Kong
Asia	Eastern Asia	Japan
Asia	Eastern Asia	Macao
Asia	Eastern Asia	Mongolia
Asia	Eastern Asia	North Korea
Asia	Eastern Asia	South Korea
Asia	Eastern Asia	Taiwan
Asia	Middle East	Armenia
...

要按多列排序，只需在 ORDER BY 子句中用逗号分隔列名。