A survivor rule must be total: when two rows tie on every column, add a tie-break such as the smallest id, so the result never depends on input order.
- Lesson: Find the row grain before removing duplicates
- Practise: Pick one surviving record per account
Related: Deduplication