Vælge nyeste timestamp
Hej,Jeg har følgende tabel:
id-id_s-navn-timestamp
1-88-mads-2021-02-01 21:21:19
2-87-peter-2021-02-01 21:21:19
3-88-mads-2022-06-09 23:00:00
4-44-ole-2021-02-01 21:21:19
5-54-lars-2021-02-01 21:21:19
ønsker resultat:
2-87-peter-2021-02-01 21:21:19
3-88-mads-2022-02-01 21:21:19
4-44-ole-2021-02-01 21:21:19
5-54-lars-2021-02-01 21:21:19
dvs. hver post med nyeste timestamp for hvert id_s