30. ROW_NUMBER, 시퀀스(SEQUENCE)

ROW_NUMBER PARTITION 내에서 ORDER BY절에 의해 정렬된 순서를 기준으로 고유한 값을 반환 e.g. SELECT ROW_NUMBER() OVER(ORDER BY SAL DESC) "테스트" , ENAME "사원명", SAL "급여", HIREDATE "입사일" FROM EMP; --==>> /* 1KING50001981-11-17 2FORD30001981-12-03 3SCOTT30001987-07-13 4JONES29751981-04-02 5BLAKE28501981-05-01 6CLARK24501981-06-09 7ALLEN16001981-02-20 8TURNER15001981-09-08 9MILLER13001982-01-23 10WARD12501981-02-22 11MARTIN125..