WITH t AS
(
SELECT '가' cd FROM dual
UNION ALL SELECT '나' FROM dual
UNION ALL SELECT '다' FROM dual
UNION ALL SELECT '다' FROM dual
UNION ALL SELECT '라' FROM dual
)
SELECT cd
     , DENSE_RANK() OVER(ORDER BY cd) dr
  FROM t
;

감사합니다 --__;