Write a SQL query to find duplicate records in a table and explain how you would clean up this test data.
