SQL: Find Duplicate Rows for One or More Fields

Here is a quick snippet to remind me how to find duplicate values on one or more values in SQL.

Credit goes to SO