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