I want to group rows with SQL, my result set is following 

name  size  date  

data1  123  12/03/2009  

data1  124  15/09/2009  

data2  333  02/09/2010  

data2  323  02/11/2010  

data2  673  02/09/2014  

data2  444  05/01/2010  

I want to group result set like this one:

data1  

  123  12/03/2009  

  124  15/09/2009  

data2  

  333  02/09/2010  

  323  02/11/2010  

  673  02/09/2014  

  444  05/01/2010  

is it possible to do this with pure SQL?

Cheers.