You can, but what if you have this type of data:

ColumnCode1  ColumnCode2  ColumnCode3   CodeCount
Code1          Code2         code3         3
Code1          Code2         Code4         2
Code3          Code1         Code4         12
Code7          Code9         Code1         21

>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