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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.