with CTE1 as ( select MAP_TRANCODE_ID, MAP_ID, TRANCODE, MAP_TYPE, DELETE_FLAG, FILE_GROUP_CODE, CATEGORY, FILE_FORMAT_ID, DATE_FORMAT_OPTION, MATCHING_KEY_ID, MAKE_ACCOUNT_OPTION, row_number() over (PARTITION BY MAP_ID, TRANCODE, MAP_TYPE, DELETE_FLAG, FILE_GROUP_CODE, CATEGORY, FILE_FORMAT_ID, DATE_FORMAT_OPTION, MATCHING_KEY_ID, MAKE_ACCOUNT_OPTION order by MAP_TRANCODE_ID) cte1_RN from TLF_MAP_TRANCODE where DELETE_FLAG = 'N' ) , CTE2 as ( select cte1_2.MAP_TRANCODE_ID, cte1_2.MAP_ID, row_number() over (PARTITION BY cte1_2.MAP_ID) cte2_RN FROM CTE1 cte1_1 Join CTE1 cte1_2 on cte1_2.MAP_ID = cte1_1.MAP_ID where cte1_1.cte1_RN > 1 and cte1_2.MAP_TRANCODE_ID in ( select MT.MAP_TRANCODE_ID AS "MT.MAP_TRANCODE_ID" from FTC.TLF_MAP_TRANCODE MT LEFT JOIN FTC.TLF_FILE_ATTRIBUTE FA on MT.MAP_TRANCODE_ID = FA.MAP_TRANCODE_ID where FA.MAP_TRANCODE_ID is null ) ) select MAP_TRANCODE_ID from TLF_MAP_TRANCODE where MAP_TRANCODE_ID in ( select MAP_TRANCODE_ID FROM CTE2 where CTE2_RN = 1 )
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.Get Access
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.