get newest rows with a GROUP BY

Hi there,

I have a table with 2 foreign keys, a date column and several other columns. I want to retrieve all the newest rows for each combination of the foreign keys, but I need the other data as well. I could join the table with itself (the combination of the foreign keys and the date is an alternate key to the table),
but maybe/probably there is a better solution.

My SELECT-Stmt:
SELECT fk1, fk2, max(date) from table_name group by fk1, fk2

Has anybody an idea?

Cheers,

Jan Received on Tue Feb 19 2002 - 16:15:49 CET