New Solution for Combining Multiple Row Values into a Single Row with SQL

The LISTAGG function makes combining row values easier.

By Kent Milligan

Several years have passed since I wrote articles on how to use the Db2 for i Connect By and Recursive Common Table Expression features to combine multiple row values into a single row. The following table represents the type of report that could be generated using the SQL detailed in those articles.

Verified by MonsterInsights