【文件属性】:
文件名称:按照列的别名来进行排序-SQL语言基础
文件大小:5.26MB
文件格式:PPT
更新时间:2021-04-25 19:38:11
SQL 基础
按照列的别名来进行排序
*
SQL> SELECT empno, ename, sal*12 annsal
2 FROM emp
3 ORDER BY annsal;
EMPNO ENAME ANNSAL
--------- ---------- ---------
7369 SMITH 9600
7900 JAMES 11400
7876 ADAMS 13200
7654 MARTIN 15000
7521 WARD 15000
7934 MILLER 15600
7844 TURNER 18000
...
14 rows selected.
*
SELECT empno, ename, sal*12 annsal
FROM emp
ORDER BY annsal;
Sorting by Column Aliases
You can use a column alias in the ORDER BY clause. The slide example sorts the data by annual salary.