In database nest STRING_AGG() function? throws invalid syntax error

Sunitha
Sunitha New Altair Community Member
edited November 2024 in Community Q&A
I tried to use string_agg() function in database nest. but it throws error whatever i used as syntax 

string_agg() WITHIN GROUP BYSTRING_AGG(email,';') WITHIN GROUP (ORDER BY email)I tried above two but no luck for me. Help me with syntax
Tagged:

Answers

  • jwpfau
    jwpfau
    Altair Employee
    Hi Sunitha,

    maybe you are missing the "AS emails" parts at the end?

    Greetings,
    Jonas

Categories