SQL to eliminate duplicates while inserting rows from source table to destination table

insert into DestinationTable
select *  from SourceTable a
 where not exists ( select 0 from DestinationTable b where b.primaryKey= a.primaryKey )