Alle neuesten Datensätze holen

[mkinzler]

SQL-Code:

Select 
  b.id, 
  a.FK_FOO,
  a.DATUM
from
  (select  
    FK_FOO,
    max(DATUM) as DATUM
   group by
     FK_FOO
   from <Tabelle) a
  join 
    <Tabelle> b on b.FK_FOO = a.FK_FOO and b.DATUM = DATUM);