Hi
I want to select out from a file, using a Group By Myfield , but want to get the most recent record if there are multiple records with the same Group by Key

e.g.
MyKey Date
A Jan 10
A Jan 15
A Jan 08

Select * group By MyKey and I want the second record to be selected
Can this be done in a select command ?

Regards,

Gerard