Check the thread title carefully :)

>There was no request to filter out none duplicates.
>
>>>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)
>>>

>>>
>>
>>These selects would not filter duplicates only. You should modify the second select into :
>>

>>SELECT field1, MIN(rn) as rn, count(*) as cntDups ;
>>			FROM temp1 GROUP BY field1 ;
>>                        having cntDups>1 ;
>>                        into cursor temp2
>>
>>SELECT field1, field2 ;
>>	FROM temp1 ;
>>	WHERE field1 + STR(rn) IN  ;
>>		(SELECT field1 + STR(rn) ;
>>			FROM temp2)
>>
>>

>>
>>>>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!