Sort by One Column 按一列排序

  1. SELECT Name
  2. FROM country
  3. ORDER BY Name

Sorting by Multipe Cloumns 多列排序

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

Sorting by Column Position 按列位置排序

SELECT Code, Region, Name
FROM country
ORDER BY 2, 3

Specifying Sort Direction 指定排序方向

SELECT Name, Population
FROM country
ORDER BY Population DESC

使用排序获取最大值

SELECT gpa
FROM user_profile
WHERE university='复旦大学' 
ORDER BY gpa DESC
LIMIT 0,1