LISTAGG
Does Active Query Builder provide the ability to parse LISTAGG functions?
Does Active Query Builder provide the ability to parse LISTAGG functions?
Hello,
You asked:
Does Active Query Builder provide the ability to parse LISTAGG functions?
Active Query Builder has support for LISTAGG with Oracle SQL syntax, but it doesn't have support for it with DB2.
With what SQL syntax you need to use this function?
Hello,
Have a look for various solutions for this problem here:
https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
Quick answer:
http://stackoverflow.com/questions/15154644/group-by-to-combine-concat-a-column