15. ORDER BY 절

SELECT ENAME "사원명", DEPTNO "부서번호", JOB "직종" , SAL "급여", SAL*12+NVL(COMM, 0) "연봉" FROM EMP ORDER BY DEPTNO ASC; -- DEPTNO -> 정렬 기준 -- ASC -> 정렬 유형 : 오름차순 SELECT ENAME "사원명", DEPTNO "부서번호", JOB "직종" , SAL "급여", SAL*12+NVL(COMM, 0) "연봉" FROM EMP ORDER BY DEPTNO; -- 오름차순은 생략 가능 SELECT ENAME "사원명", DEPTNO "부서번호", JOB "직종" , SAL "급여", SAL*12+NVL(COMM, 0) "연봉" FROM EMP ORDER BY DEPTNO DESC; -- DESC -> ..