그룹별 ROWNUM 만들기

SELECT 

    col1,

    col2,

    col3,

    col4,

    ROW_NUMBER() OVER ( partition by col1,col2,col3,col4 ORDER BY col1,col2,col3,col4) AS RN

FROM tbl1

ORDER BY col1,col2,col3,col4