>Fabio,
>Thank you very much for another solution. It worked as I expected it to work.
>It took me a little bit longer to read (i.e. comprehend) your solution compared to Segey's solution. Would you care to comment on which solution you think is "better", yours or Sergey's?
>
>Thanks,
>Einar
>
If you have to project all the Table, GROUP ( Fabio's ) solution should to be better,
for a single
fk
the WHERE ( Sergey's )selection should to be.
>>
>>
>>SELECT Table.*
>> FROM Table
>> JOIN (SELECT fk,MIN(date) mind,MAX(date) maxd FROM Table GROUP BY fk) X
>> ON X.fk=Table.fk AND Table.date IN (X.mind,X.maxd)
>>
>>