You can found a solution with GROUP BY , but it can return good results only with a not fragmented datasession.
CLOSETABLESclearCREATECURSOR aa (f1 i, f2 i)
FOR k=1TO 100
INSERTINTO aa VALUES ( RECCOUNT()%5,RECCOUNT())
nextSELECT f1,MAX(f2),RECNO('D') from aa GROUPBY1