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