New answers tagged duplication
Your question is a bit light on definitions. Assuming: You define the "least amount of information" with how many of the relevant columns are NULL. Primary key is adr_id. Duplicates are marked with a column dupe_id to indicate groups of duplicates. Since it's also vague what to do exactly, I create a separate table with the dupe ranking: CRATE TABLE ...
Top 50 recent answers are included