Can you use SELECT TOP 1 and then order it by codecount desc?

>I feel like I've done this before but for the life of me I can't remember how I did it:
>
>Using just SQL Select how can I get the items with the Max count.
>

>Source table
>
>ColumnCode1  ColumnCode2  ColumnCode3   CodeCount
>Code1          Code2         code3         3
>Code1          Code2         Code4         2
>

>
>What I'm trying to get to is for each identical ColumnCode1, ColumnCode2 I want to see only the ColumnCode3 with the most CodeCount.
>
>Something like this:
>

>ColumnCode1  ColumnCode2  ColumnCode3
>Code1          Code2         code3
>

>
>Any ideas?
>
>Richard