Thread SQL-Frage: Groessten Wert fuer jede ID in Tabelle (15 answers)
Opened by nepos at 2006-04-06 13:29

nepos
 2006-04-06 17:30
#34252 #34252
User since
2005-08-17
1420 Artikel
BenutzerIn
[Homepage] [default_avatar]
Geht sogar noch einfacher hab ich grade gesehen:
Code: (dl )
1
2
3
4
5
SELECT * FROM component_history AS ch WHERE history_timestamp = (
  -- Suche den groessten Timestamp fuer die ID
  SELECT history_timestamp FROM component_history WHERE component_id=ch.component_id ORDER BY history_timestamp DESC LIMIT 1
  )
ORDER BY component_id;

View full thread SQL-Frage: Groessten Wert fuer jede ID in Tabelle