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