title: how to select a row based on a single distinct value
body: <p>If i have 4 rows and want to select rows based on a single column's distinct values and dont mind which info it uses for the rest of the row, how do i do this? There doesn't seem to be a 'distinct' function for single cols whilst maintaining rest of row data.</p>
  
  <p>eg</p>
  
  <pre><code>Name, value
  john 1
  john 2
  michael 3
  michael 5
  </code></pre>
  
  <p>result</p>
  
  <pre><code>john 1
  michael 5
  </code></pre>
  
  <p>note it could have been john 2 or michael 3, i dont care which row for John or Michael it uses for the rest of the values.</p>