Then the following should do it for you. Please understand that I've not actually tested the code. Please see the first link in my signature line below for why and how to get really good answers to your posts in the future.

SELECT ComCod = MIN(COMCOD)

, PartyCode = MIN(PartyCode)

, PartyName

FROM dbo.YourTable

GROUP BY PartyName

ORDER BY PartyName

;