Concatenate Strings from a Column Into a Single Row

Sometimes there is a need to concatenate strings from a column into a single row. Some databases already provide a solution with the GROUP_CONCAT() aggregate function, such as SQLite and MySQL. In DB2 you can use the XMLAGG() function to Continue reading Concatenate Strings from a Column Into a Single Row