lundi 14 décembre 2015

Sql select group by and comma seperated string

After applying innerjoin and I got table as

Size   Planet

Big    Jupiter
Big    Saturn
Big    Earth
Small  Pluto
Small  Venus

now i want this to group such that column planet will have comma separated values in sql.

i.e

Size   Planet

Big    Jupiter,Saturn,Earth
Small  Pluto,Venus

Thanks.

Aucun commentaire:

Enregistrer un commentaire