Then again, maybe a little more description on what you seek.

Are you just trying to eliminate dupes in your output, or eliminate dupes from the table?

If you are trying to delete dupes, how do you know they are dupes? PartyCode is unique in each of those cases, what is the significance of that column?

Are these the results from a table, or are they from a view that selects from multiple tables?