Sorting by column alias

You can use the column alias if you want a more expressive title for data

For example

Select ename,sal,empno ,sal+100  bounce

From emp

Order by bounce;

ENAME             SAL      EMPNO     BOUNCE

---------- ---------- ---------- ----------

SMITH             800       7369        900

JAMES             950       7900       1050

ADAMS            1100       7876       1200

WARD             1250       7521       1350

MARTIN           1250       7654       1350

MILLER           1300       7934       1400

TURNER           1500       7844       1600

ALLEN            1600       7499       1700

CLARK            2450       7782       2550

BLAKE            2850       7698       2950

JONES            2975       7566       3075

ENAME             SAL      EMPNO     BOUNCE

---------- ---------- ---------- ----------

SCOTT            3000       7788       3100

FORD             3000       7902       3100

KING             5000       7839       5100