title: Select DISTINCT, return entire row
body: <p>I have a table with 10 columns.
  I want to return all rows for which Col006 is distinct, but return all columns...</p>
  
  <p>How can I do this?</p>
  
  <p>if column 6 appears like this:</p>
  
  <pre><code>| Column 6 |
  | item1    | 
  | item1    | 
  | item2    | 
  | item1    | 
  </code></pre>
  
  <p>I want to return two rows, one of the records with item1 and the other with item2, along with all other columns.</p>