Write a query to find duplicate records in a table based on a specific column, and explain how you would delete them.
