>>Group by pkfield ?
>>
>>select * from myTable A where datefield = ;
>> (select min(datefield) from myTable B where a.pkfield = b.pkfield) ;
>> order by pkfield
>>
>
>It was with the primary key but you pretty much gave the same answer as the others. Thanks
Yes it was my mistake to say pkfield. It'd be groupingField(s). Otherwise result is all records.
Cetin