순위함수

SELECT 
       E.ENAME
       ,E.SAL
       ,RANK () OVER (ORDER BY E.SAL DESC) AS RANK
       ,DENSE_RANK () OVER (ORDER BY E.SAL DESC) AS DENSE_RANK
       ,ROW_NUMBER () OVER (ORDER BY E.SAL DESC) AS ROW_NUMBER
FROM EMP E;

결과