Delete duplicated rows on SQL

Assuming these are the incriminated records

duplicate_records

 

 

 

 

 

 

 

 

 

Let’s narrow down the duplicate ones by grouping the records and removing from the resultset the first valid record and by leaving the duplicates only.

narrow_records_duplicate

 

 

 

 

 

 

 

Let’s delete them now.

delete_records_duplicate

 




No Comments


You can leave the first : )



Leave a Reply

Your email address will not be published. Required fields are marked *