Delete duplicated rows on SQL

Assuming these are the incriminated 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.









Let’s delete them now.



No Comments

You can leave the first : )

Leave a Reply

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