How do you handle duplicate records in a dataset using SQL? Write a query using window functions to identify and remove duplicates.
