{{theTime}}

Search This Blog

Total Pageviews

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 )

No comments:

MongoDB Tutorial MongoDB Tutorial Table of Contents Introduction to MongoDB Installation Creating a Database Creati...