SQL statement Merge column values combine multiple values from a column into one row

Effect:

Oralce notation:

Select Wm_concat (a.title) as Citys from Tmpcity A

SQL Server notation:

Select Stuff ((select ', ' +a.title from tmpcity A for XML PATH (') '), 1, 1, ") as Citys

MySQL notation:

Select Group_concat (a.title) as citys from Tmpcity A; --The default comma-delimited
Select Group_concat (A.title SEPARATOR ") as Citys from Tmpcity A; --separated by a space

SQL statement Merge column values combine multiple values from a column into one row