Retrieve duplicate values in a database table with SQL
There was an error with one of our applications, and I needed to find table rows with duplicate values. The table column was not defined to have a unique index, but we weren't anticipating duplicate values. I needed an easier way to identify duplicate values in a table with a simple SQL statement.