Your question is Find Duplicate Rows Query. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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 |