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