asked
bm table has duplicate rows in it . but i want to merge the bmto fbm without any dupplicate rows
MERGE INTO fbm f USING (select distinct * form bm b) ON (f.EMPLOYEE_ID= b.EMPLOYEE_ID) WHEN MATCHED THEN UPDATE SET f.EMPLOYEE_ID = b.EMPLOYEE_ID WHEN NOT MATCHED THEN INSERT VALUES(b.EMPLOYEE_ID);
Please post the DDL of the tables, some dummy data and output required.
18 People are following this question.
