Interview question, ‘You have this table with a ‘billion’ rows that have duplicates, how do you fix that?’ : SQLServer

So I was on an interview last week and got posed this question by an interviewer. It’s a good question for sure, I gave the usual solutions that I…