db2 Combine multiple rows into a single comma separated value Using the listagg() function


Let's say you've got a table of loans, and another related table of parcels, where each loan can have one or more parcels associated with it. If you want a query to show each loan and a list of all its associated parcels, but you only want each loan to show up once, then you could use something like this:

  parcel_agg.p_list as parcel_list 
  schema.loan loan 
  left join 
  ( select loannumber, listagg(parcelnum, ', ') from schema.parcel parcel group by loannumber ) parcel_agg on parcel_agg.loannumber = loan.loannumber