[[{“value”:”I did not realize it had been so long since I first wrote about the LISTAGG scalar function. I mentioned very briefly in that article something that became very useful to me just a short while ago.
The LISTAGG scalar function aggregates the results from a one or more rows into a single new column, separated by a character of my choice.
In my scenario I have a table, TESTTABLE, that contains a column of colors, COLOR:
01 SELECT COLOR,COUNT(*) “Count”
02 FROM TESTTABLE
03 GROUP BY COLOR
Read more »”}]] Read More
