{{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:

BlockingQueue Applications

Java BlockingQueue is a versatile data structure that can be used in various real-time scenarios where multiple threads need to communicate ...