title: How to combine rows in Amazon Redshift
body: <p>I am using Amazon redshift.
  How do I combine the result of the columns.</p>
  
  <p>If the original rows are:</p>
  
  <pre><code>*ID   Name  Color
  ----------------
  1   John   White
  1   John   Black
  2   Mark   Blue
  2   Mark   Red*
  </code></pre>
  
  <p>the result should be:</p>
  
  <pre><code>*ID   Name  Color
  ----------------
  1   John   White Black
  2   Mark   Blue Red*
  </code></pre>