title: How to select all tuples determined id and newest timestamp
body: <p>Given a table:</p>
  
  <pre><code>id | timestmap | ..otherstuff..
  </code></pre>
  
  <p>with primary key (id,timestmap). Where id is of type integer and timestamp is a timestamp.</p>
  
  <p>How can I extract all tupes of which timestamp is the newest for that tuple?</p>
  
  <p>E.g. if this is the current data:</p>
  
  <pre><code>1 | 1999-05-23 0:00 | ...
  2 | 2000-05-23 0:00 | ...
  1 | 2000-06-22 0:00 | ...
  </code></pre>
  
  <p>I want the result exactly to be (though the order is a bonus I do not exactly care for)</p>
  
  <pre><code>1 | 2000-06-22 0:00 | ...
  2 | 2000-05-23 0:00 | ...
  </code></pre>