Find Duplicates in SQL

Find out how to use SQL to find duplicates in a table. In addition, learn how to retrieve all records that contain duplicates.