order by(정렬)

내림차순 : desc

mysql> select ename, sal
    -> from emp
    -> order by sal;
+--------+------+
| ename  | sal  |
+--------+------+
| SMITH  |  800 |
| JAMES  |  950 |
| ADAMS  | 1100 |
| WARD   | 1250 |
| MARTIN | 1250 |
| MILLER | 1300 |
| TURNER | 1500 |
| ALLEN  | 1600 |
| CLARK  | 2450 |
| BLAKE  | 2850 |
| JONES  | 2975 |
| SCOTT  | 3000 |
| FORD   | 3000 |
| KING   | 9999 |
+--------+------+
14 rows in set (0.00 sec)

mysql> select ename, job
    -> from emp
    -> order by hiredate
    -> ;
+--------+-----------+
| ename  | job       |
+--------+-----------+
| SMITH  | CLERK     |
| ALLEN  | SALESMAN  |
| WARD   | SALESMAN  |
| JONES  | MANAGER   |
| BLAKE  | MANAGER   |
| CLARK  | MANAGER   |
| TURNER | SALESMAN  |
| MARTIN | SALESMAN  |
| KING   | PRESIDENT |
| JAMES  | CLERK     |
| FORD   | ANALYST   |
| MILLER | CLERK     |
| SCOTT  | ANALYST   |
| ADAMS  | CLERK     |
+--------+-----------+
14 rows in set (0.00 sec)