Lowe's Home Improvement interview question

Find duplicate records in a table using SQL.