title: SQL - How do you select the first row (or any unique row) of multiple rows with the same ID?
body: <p>Let's say I have a query result that looks as follows:</p>
  
  <pre><code>ID    NAME    Phone
  ----  ----    -----
  1     Bob     111-111-1111
  1     Bob     222-222-2222
  1     Bob     333-333-3333
  2     Stan    555-555-5555
  3     Mike    888-888-8888
  3     Mike    777-777-7777
  </code></pre>
  
  <p>I want to return just a single row instance of each ID value.  It doesn't matter to me which one of the multiple rows I get - the first in the set is ok.</p>
  
  <p>So a possible result would be:</p>
  
  <pre><code>ID    NAME    Phone
  ----  ----    -----
  1     Bob     111-111-1111
  2     Stan    555-555-5555
  3     Mike    888-888-8888
  </code></pre>