Force data into unique row format

[jonnytekno]

I have marketing campaign some data where there is a unique campaign id and then a campaign name. 

But, there can sometimes be more than one campaign name for a single campaign id - this means joining the campaign name to other data where the campaign id exists is hard. I want to be able to force the data into a table where the campaignid and campaign name are always unique, which means I need to drop one of the campaign names, but don't care which (they are practically identical apart from typos etc)

How can I do a select id, name from [table] group by id, name where I know that the id is never going to be duplicated?

[justsomeguy]

You'll need to get the list of IDs and names and figure out which one to use, and just insert that data into the new table.