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...