Write a SQL query to find and remove duplicate rows while keeping the most recent record per business key.
