[오라클]그룹별 순번 만들기

SELECT

MASTER_CODE

,CODE

,VALUE

,RANK() OVER(PARTITION BY MASTER_CODE ORDER BY MASTER_CODE, CODE)

from NAME_MT

ORDER BY MASTER_CODE, CODE ;