>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