[ Oracle ]
ROW_NUMBER()
2019-04-15 17:59:40
그룹별 ROWNUM 주기 SELECT ROW_NUMBER() OVER(PARTITION BY COLUMN.A ORDER BY COLUMN.A, COLUMN.B) AS RNUM, COLUMN.A, COLUMN.B FROM TABLE GROUP BY COLUMN.A, COLUMN.B (EXAMPLE) SELECT ITEM_NM, GT FROM ZTMP_EI_BND ITEM GT NETWORK EQUIPMENT1 6 NETWORK EQUIPMENT2 3.5 NETWORK EQUIPMENT3 3.7 NETWORK EQUIPMENT4 3.5 NETWORK EQUIPMENT5 7.1 USED NETWORK EQUIPMENT1 2.3 USED NETWORK EQUIPMENT2 6.5 USED NETWORK EQUIP..