This website uses cookies to ensure you get the best experience.
Learn more.
Two customer rows have the same key but different UpdatedAt timestamps. You must retain the latest row deterministically. Which design is safest?
Published
- Remove duplicates without defining a survivor
- Replace both timestamps with today's date
- Append the customer table to itself
- Group by key and select the row with the maximum timestamp
Comments — 0
Sign in to comment