title: How to select unique values for a column where the IDs are different?
body: <p>I have a select statement that is returning an ID column and value column. The values in the ID column are distinct, but there are duplicates in the value column. </p>
  
  <p>Here is an example: </p>
  
  <pre><code>    ID    |    Value
  -----------------------
      1     |     Bob
      2     |     Jane
      3     |     Bob
      4     |     Mike
      5     |     Suzy
      6     |     Mike
  </code></pre>
  
  <p>As you can see there are 4 unique name values but 6 records returned because the IDs are all different. This normally should not be done, but this is just example data (not really using names) and for what I need to do I need to remove records with duplicate names. </p>
  
  <p>I was trying to use the lead or lag function but couldn't get it to remove the duplicates. </p>
  
  <p>Any ideas on how to modify a straight forward select statement to get both columns but with only unique names?</p>