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....