ORDER BY 排序根据指定列对结果集排序ASC ascend 升序(默认)DESC descend 降序 SELECT Column1, column2, ... FROM table WHERE condition(s) ORDER BY column1 ASC/DESC,column2 ASC/DESC 如果一列升序,一列降序 SELECT *FROM moviesORDER BY director ASC, year DESC