How would you delete duplicate rows from a table when there is no key column?
Use PostgreSQL and assume that duplicate rows match across every column. Keep one copy of each distinct row and remove the remaining copies from claim_ingest.
member_id, claim_date, procedure_code, paid_amount, and status for each deleted row.member_id, claim_date, procedure_code, paid_amount, and status, ascending with NULL values last.| Column | Type | Description |
|---|---|---|
| member_id | INT | Member identifier from the source claim feed |
| claim_date | DATE | Date associated with the claim |
| procedure_code | VARCHAR(10) | Medical procedure code |
| paid_amount | NUMERIC(10,2) | Amount paid for the claim |
| status | VARCHAR(20) | Claim processing status |