So in my day job I was asked to investigate why some data was not matching up. After a bit of investigation I found a table that had 90-95% of it's records duplicated, so I needed a way of removing...

There are many ways of detecting duplicate data in your tables. One of the quick and easiest methods I have found is to use the below syntax.

It will return a list of duplicate entries by the...