DB2 combines multiple row records into one row

DB2 merges multiple rows into one row DB2 merges the same field of multiple records, for example, A B1 a1 b1 c2 d2 f www.2cto.com is converted into the following: A B1 a, B, c2 d, f found A lot of information on the Internet, and now share a solution provided by someone else: The premise is that the database supports XMLselect A, replace (xml2clob (xmlelement (NAME, B | ','), '<A>', ''), '</A>','') FROM TABLE GROUP BY A, although not very familiar, record it first and retrieve it directly later!