24. RANK()

RANK() → 등수(순위)를 반환하는 함수 SELECT EMPNO "사원번호", ENAME "사원명", DEPTNO "부서번호", SAL "급여" , RANK() OVER(ORDER BY SAL DESC) "전체급여순위" -- (내림차순으로 순위) FROM EMP; --==>> /* 7839KING105000 1 7902FORD203000 2 : 7900JAMES30 95013 7369SMITH20 80014 */ PARTITION BY SELECT EMPNO "사원번호", ENAME "사원명", DEPTNO "부서번호", SAL "급여" , RANK() OVER(PARTITION BY DEPTNO ORDER BY SAL DESC) "부서별급여순위" , RANK() OVER(ORDER BY SAL DE..