title: Using MySQL, I want to SELECTmultiple columns and use GROUP BY but only show the grouped by column once per grouping
body: <p>At present, a column the the rows are grouped by is displayed for each row. I want to only display the column when the grouping changes.</p>
  
  <p>eg:</p>
  
  <pre><code>water  sea
         ocean
         river
  sand   beach
         desert
  trees  woods
         forest
  </code></pre>