title: Oracle - Unique values from a single column, but returning other columns
body: <p>I'm trying to figure out how pull select values from a table column, but return other results as well.  For example say I have the following table</p>
  
  <pre><code>person  ..........
  ------------------
  bob     ..........
  mary    ..........
  bob     ..........
  sue     ..........
  </code></pre>
  
  <p>What I want to return back is</p>
  
  <pre><code>bob     ..........
  mary    ..........
  sue     ..........
  </code></pre>
  
  <p>In this case I don't care what values I am actually receiving back for bob from the other columns how would I do that?</p>
  
  <hr>
  
  <p>Follow up question, what if I did care though?  What if I had this table</p>
  
  <pre><code>person  type    color   ..........
  ----------------------------------
  bob     0       blue    ..........
  mary    1       green   ..........
  bob     1       red     ..........
  sue     0       yellow  ..........
  </code></pre>
  
  <p>And this time I again want unique people, but I want the results back for bob when his type is 0, so for him I would see</p>
  
  <pre><code>bob     0   blue    ..........
  mary    1   green   ..........
  sue     0   yellow  ..........
  </code></pre>
  
  <p>Thanks!</p>