ORDER BY子句
SELECT [DISTINCT] {COLUMN } FROM TABLE [ORDER BY {COLUMN}]
·ORDER BY 子句在整个SELECT语句中,始终位于最后
·ORDER BY 后面可以接列名,列的别名,表达式,列出现在SELECT关键字后列的序号
·ORDER BY 后面可以跟多列,表示先按第一列排序,如果第一列有相同的值,再按照第二列排序,如果前两列均相同,则按照第三列排序。
·ASC表示升序排列,可以省略。DESC表示降序排列
example 1:
SELECT LAST_NAME, DEPT_ID, START_DATE
FROM S_EMP
ORDER BY LAST_NAME;
example 2:
SELECT LAST_NAME EMPLOYEE, START_DATE
FROM S_EMP
ORDER BY EMPLOYEE DESC;
example 3:
按照salary * 12 这列的值来排序
SELECT LAST_NAME, SALARY * 12
FROM S_EMP
ORDER BY 2;
效果等同于:
SELECT LAST_NAME, SALARY * 12
FROM S_EMP
ORDER BY SALARY * 12;
example 4:
按照salary * 12 这列的值来排序
SELECT LAST_NAME, DEPT_ID, SALARY
FROM S_EMP
ORDER BY DEPT_ID, SALARY DESC;