Given a table:

```
id | timestmap | ..otherstuff..

```

with primary key (id,timestmap). Where id is of type integer and timestamp is a timestamp.

How can I extract all tupes of which timestamp is the newest for that tuple?

E.g. if this is the current data:

```
1 | 1999-05-23 0:00 | ...
2 | 2000-05-23 0:00 | ...
1 | 2000-06-22 0:00 | ...

```

I want the result exactly to be (though the order is a bonus I do not exactly care for)

```
1 | 2000-06-22 0:00 | ...
2 | 2000-05-23 0:00 | ...

```