Hi Ed.

On further investigation, it is not doing exactly as I want, if I do a select *. I want the Highest Flda RECORD returned

Flda Fldb Fldc Fldd Flde etc
A 100
A 300
A 150
B 500
B 800
B 600

If I Select SELECT *, MAX(Fldb) AS C FROM TempFile GROUP BY C, it returns

Flda Fldb C
A 150 300 Record no. 3 from File above
B 600 800 Record no. 6 from File above

What I want returned is:
A 300 Record no. 2 above
B 800 Record no. 5 above

The file above is just a sample for illustration purposes. I am reaaly in terested in the other fields that are in the file, and I need the record whch has the highest FldB value returned , for any of the records grouped by Flda.

Regards
Gerard




>>Hi.
>>I'm wondering is there a SQL statemnt to do the following:
>>
>>My File has two fields:
>>Flda Fldb
>>---- ----
>>A 100
>>A 200
>>A 300
>>D 105
>>D 107
>>E 153
>>E 156
>>
>>I want as a result:
>>A 300
>>D 107
>>E 156
>>i.e. The highest record based on the Flda field
>
>SELECT flda, MAX(fldb) FROM MyFile GROUP BY Flda