其他的答案缺乏一个具体的例子,因此下面是:
鉴于以下情况人民表:FirstName | LastName | YearOfBirth----------------------------------------
Thomas | Alva Edison | 1847
Benjamin | Franklin | 1706
Thomas | More | 1478
Thomas | Jefferson | 1826
如果执行以下查询:SELECT * FROM People ORDER BY FirstName DESC, YearOfBirth ASC
结果集将如下所示:FirstName | LastName | YearOfBirth----------------------------------------
Thomas | More | 1478
Thomas | Jefferson | 1826
Thomas | Alva Edison | 1847
Benjamin | Franklin | 1706