title: Sql group rows with same value, and put that value into header?
body: <p>I want to group rows with SQL, my result set is following </p>
  
  <p>name&nbsp;&nbsp;size&nbsp;&nbsp;date<br />
  data1&nbsp;&nbsp;123&nbsp;&nbsp;12/03/2009<br />
  data1&nbsp;&nbsp;124&nbsp;&nbsp;15/09/2009<br />
  data2&nbsp;&nbsp;333&nbsp;&nbsp;02/09/2010<br />
  data2&nbsp;&nbsp;323&nbsp;&nbsp;02/11/2010<br />
  data2&nbsp;&nbsp;673&nbsp;&nbsp;02/09/2014<br />
  data2&nbsp;&nbsp;444&nbsp;&nbsp;05/01/2010<br /></p>
  
  <p>I want to group result set like this one:</p>
  
  <p>data1<br />
  &nbsp;&nbsp;123&nbsp;&nbsp;12/03/2009<br />
  &nbsp;&nbsp;124&nbsp;&nbsp;15/09/2009<br />
  data2<br />
  &nbsp;&nbsp;333&nbsp;&nbsp;02/09/2010<br />
  &nbsp;&nbsp;323&nbsp;&nbsp;02/11/2010<br />
  &nbsp;&nbsp;673&nbsp;&nbsp;02/09/2014<br />
  &nbsp;&nbsp;444&nbsp;&nbsp;05/01/2010<br /></p>
  
  <p>is it possible to do this with pure SQL?</p>
  
  <p>Cheers.</p>