For example I have two column c_id (int),and c_name (char) in table x1

my select must be
select concate(c_name) from x1 group by c_id

but I can't concatenate the column c_name,becouse I don't know a command like a concate string columns in SQL.