string_agg application

[jbrotto]

I am trying to aggregate some text from all my numAtCard fields would this function make sense?

string_agg

[OlehFabri · Accepted solution]

Hi Jonathan,

In the example below, the STRING_AGG function will retrieve all NumAtCard values from the ORDR table and concatenate them in a string with a comma separator between the values. NULL values will be ignored.

SELECT STRING_AGG(NumAtCard,',') AS NumAtCard FROM ORDR