Tag Archives: group

Group and concatenate rows

If we have a table like this: id name year 1 museum 2 2012 2 museum 1 2012 3 museum 2 2010 4 museum 1 2011 5 museum 3 2012 And we want to list all the museums and on which year they..well, they did something. Something like this result: name year museum 1 2012,2011… Read More »