SQL 정렬 (ORDER BY ASC, ORDER BY DESC)

//오름차순 order by empno asc;
  //asc는 생략 가능
//내림차순 order by empno desc;

@ 사원번호 오름차순 정렬
SQL> select *
  2  from emp
  3  order by empno;

@ 사원번호 내림차순 정렬
SQL> select *
  2  from emp
  3  order by empno desc;

@ 급여 오름차순 정렬
SQL> select *
  2  from emp
  3  order by sal (asc);

@ 급여 내림차순 정렬
SQL> select *
  2  from emp
  3  order by sal desc;

@ 최근 입사한 순서로 정렬
SQL> select empno, ename, job, hiredate
  2  from emp
  3  order by hiredate desc;

@ 사원번호 오름차순 정렬
SQL> select empno, ename
  2  from emp
  3  order by empno asc;

@ deptno 오름차순 정렬 후 sal 오름차 정렬
SQL> select empno, ename, sal, deptno
  2  from emp
  3  order by deptno asc, sal asc;

@ sal 오름차순 정렬 후 deptno 오름차순 정렬
SQL> select empno, ename, sal, deptno
  2  from emp
  3  order by sal asc, deptno asc;

@ deptno s내림차순 정렬 후 sal 오름차 정렬
SQL> select empno, ename, sal, deptno
  2  from emp
  3  order by deptno desc, sal asc;