General information
Category:
Coding, syntax & commands
Ed,
Thanks for your reply. Works great !!
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only