Write a SQL query to identify duplicate records in a high-volume transactional table and keep only the most recent entry.
You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.
