SQL-Abfrage für eine Historie

[Vimes]

Moin Wagymam

personen_id  |  nachricht_id  |  nachricht  |  datum     |

1001         |        1       | bla, bla... | 2002-11-21 |

1001         |        2       | bla, bla... | 2002-11-21 |

1001         |        3       | bla, blub.. | 2002-11-21 |

1002         |        1       | bla, bla... | 2002-11-21 |

1003         |        1       | bla, bla... | 2002-11-18 |

...

Zauberwörter GROUP BY und ORDER BY
also
select * from Mitteilungen Group by personen_id order by datum desc;