title: Hide duplicate results in MySQL query
body: <p>I have a query in which I group results:
  <code>
      SELECT brand, description, prodcode
      FROM table
      GROUP BY brand, prodcode
  </code>
  Now the results are:</p>
  
  <pre><code>brand | description | prodcode
  ------------------------------
  Brand1, Description1, Product1
  Brand1, Description2, Product2
  Brand1, Description3, Product4
  </code></pre>
  
  <p>What I would like to see is:</p>
  
  <pre><code>brand | description | prodcode
  ------------------------------
  Brand1, Description1, Product1
          Description2, Product2
          Description3, Product4
  </code></pre>
  
  <p>Any ideas how to suppress this duplicate data before sending it to the application layer?</p>