title: Selecting compared pairs from table
body: <p>I don't really know how to describe it. I have a table:</p>
  
  <pre><code>ID |   Name  | Date
  -------------------------
   1 | Mike    | 01.01.2016
   1 | Michael | 02.03.2016
   2 | Samuel  | 23.12.2015
   2 | Sam     | 05.03.2015
   3 | Tony    | 02.04.2012
  </code></pre>
  
  <p>I want to select pairs of IDs and Names with latest dates in each pair. The result here should be:</p>
  
  <pre><code>ID |   Name  | Date
  -------------------------
   1 | Michael | 02.03.2016
   2 | Samuel  | 23.12.2015
   3 | Tony    | 02.04.2012
  </code></pre>
  
  <p>How do I achieve this?</p>
  
  <p>Oracle Database 11g</p>