Write a SQL query to identify duplicate records in a transaction table and describe how you would clean them without losing historical audit trails.
