Check duplicates in DB

Hi All,

I have a table Emp_personal_details and i have around 200 records in that table.

Now I need to Insert around 400 new records into the same table. But the new records have some duplicates which are already in the DB.

How can I write a sql script to check duplicates in the table and insert the remaining records into the Appian DB.

Thanks

  Discussion posts and replies are publicly visible