You can do this in two selects

SELECT field1, field2 , RECNO() AS rn ;
	FROM test2 ;
	INTO CURSOR temp1

SELECT field1, field2 ;
	FROM temp1 ;
	WHERE field1 + STR(rn) IN ( ;
		SELECT field1 + STR(MIN(rn)) ;
			FROM temp1 GROUP BY field1)

>field1,field2
>abarca,2243
>abarca,3314
>abarca,2142
>
>I need to get the 1st record: abarca, 2243.
>SELECT * from table1 GROUP BY field1: returns the last record (abarca, 2142).
>What would be the correct SQL statement to do so?
>
>Thank you all!