Write a basic SQL query to find the duplicate records in a transaction table and explain how you would remove them.
