Using Common Table Expressions (CTEs) to delete duplicates in SQL query

• Use a CTE to identify duplicates by ranking rows based on a unique identifier

• Delete rows with duplicate ranks in the main query