You can found a solution with GROUP BY ,
but it can return good results only with a not fragmented datasession.

CLOSE TABLES
clear
CREATE CURSOR aa (f1 i, f2 i)
FOR k=1 TO 100
INSERT INTO aa VALUES ( RECCOUNT()%5,RECCOUNT())
next
SELECT f1,MAX(f2),RECNO('D') from aa GROUP BY 1