>I have a SQL which contains a GROUP BY clause. For the record that will be extract for each group, I need to extract the oldest one. I have a primary field that could be used for that. Basically, the lowest value in the primary field determines the first record that was created in that group. I'm trying to find the best approach in the SQL to achieve that.

Group by pkfield ?

select * from myTable A where datefield = ;
 (select min(datefield) from myTable B where a.pkfield = b.pkfield) ;
 order by pkfield

If no datetimefield or such (physically entered first is oldest) - requires 70 compatibility in VFP8 :

select *,sys(2015) as dummyorder ;
 from myTable ;
 order by DummyOrder descending ;
 into cursor crsTemp nofilter

select .... from crStemp group by ....

Cetin