The other day, someone asked me if there was a simple way to figure out if a db table contains duplicate records. The answer is yes and the good news is that it’s very easy to do.
Let’s say you have an Employee table and want to find out if it contains any duplicate SSNs. This [...]