Two customer rows have the same key but different UpdatedAt timestamps. You must retain the latest row deterministically. Which design is safest?

Published
  1. Remove duplicates without defining a survivor
  2. Replace both timestamps with today's date
  3. Append the customer table to itself
  4. Group by key and select the row with the maximum timestamp

Comments — 0