Prompt WM_CONCAT identifier is invalid, please warrior to solution

CodePudding user response:

Using listagg (merge fields, 'connection symbol) within group (order by field)

CodePudding user response:

Listagg () + within group group by
Or:
Listagg () + over (partition by)