dense_rank함수 썸네일형 리스트형 오라클함수 rank()와 dense_rank()의 차이점 WITH TEMP AS ( SELECT '1' CD, 'AAA' DESC_TEXT FROM DUAL UNION ALL SELECT '1' CD, 'ASD' DESC_TEXT FROM DUAL UNION ALL SELECT '2' CD, 'SDF' DESC_TEXT FROM DUAL UNION ALL SELECT '3' CD, 'ASA' DESC_TEXT FROM DUAL UNION ALL SELECT '3' CD, 'RRR' DESC_TEXT FROM DUAL UNION ALL SELECT '4' CD, 'DDD' DESC_TEXT FROM DUAL ) SELECT A.* , RANK() OVER(ORDER BY CD) RN , DENSE_RANK() OVER (ORDER BY CD) DRN FROM T.. 더보기 이전 1 다음
