Dover India’s Asset Registry contains imported equipment records from multiple operational systems. Some records may have been loaded more than once, so the data team needs to identify duplicate business records.
Write a PostgreSQL query that identifies duplicate rows based on employee_code, email, department, and work_location. Treat record_id as a unique technical identifier and do not use it when determining duplicates.
duplicate_count descending and then employee_code ascending.| Column | Type | Description |
|---|---|---|
| record_idPK | INTEGER | Unique technical record identifier |
| employee_code | VARCHAR(20) | Employee or asset owner code |
| VARCHAR(150) | Registered contact email | |
| department | VARCHAR(80) | Dover India department |
| work_location | VARCHAR(80) | Assigned work location |