My savior! (again) Thanks! (That was embarrassing by the way - can't believe I got a brain cramp on that one) *G*



>

>SELECT Company, MAX( Number)
>...
>GROUP BY Company 
>

>
>>sQL SERVER 2000
>>
>>A company field and a number field in each record. I want to find the highest number used in the number field for each company.
>>
>>Ex:
>>

>>Company         Number
>>ABC               1
>>DEF               1
>>DEF               2
>>DEF               3
>>GHI               1
>>
>>Should pull:
>>
>>ABC     1
>>DEF     3
>>GHI     1
>>

>>
>>I just can't get it....