ROWNUMBER() OVER() 중복건 파티션묶기
* ROWNUMBER() OVER(PARTITION BY T1.N_CONT ORDER BY T1.N_CONT ) AS NUMBER DB2 Query) SELECT ROWNUMBER() OVER(PARTITION BY T1.N_CONT ORDER BY T1.N_CONT ) AS NUMBER , T1.N_CONT , CHAR(T1.R_FINAL)||'%' as Our_share, T2.D_OFACP , T2.D_CFROM, T2.D_CTO , T2.C_RITYPE , T5.R_USDEX , T2.c_intpd, T2.c_intmb, T2.c_intbi, T2.c_intcgl, T2.c_intoth, T2.C_LOC , T2.c_covfa, T2.c_coveq, T2.c_covtp, T2.c_covdl, T2..
더보기
