title: Select top entry per ID from data table - SQL
body: <p>Assuming I have the following data table: </p>
  
  <pre><code>ID       VALUE 
  ---      ------- 
  123      a
  123      b
  456      c
  456      d
  789      e
  </code></pre>
  
  <p>How can I get the output to only select the top entry per ID, assuming the data is already ordered. Ie, I need the data to show:</p>
  
  <pre><code>ID       VALUE
  ---      -------
  123      a
  456      c
  789      e
  </code></pre>