This is such a handy little thing that I've used a fair amount. It's quite frequent that I refactor code, sometimes even breaking the code into new projects.

The challenge with this is the history of the file disappears with it making it difficult to remember the previous state of that file. Enter git log

The following article will provide a single SQL query that will delete rows that are duplicated in your table. Before you begin, be sure you've tracked down the bad code that is causing this; otherwise, you will need to run it multiple times!

To start, I will create a basic table structure that will help understand the SQL query: