I have a table with multiple rows and a single column called ID - it is aways 5 chars long
I want to create a view with a single column output and a single row output that will concatentate all the values inserting a comma between each with a pre- and sufix as shown
In TSQL i would use STUFF and FOR XML PATH.
Does anyone know of a way to achieve this in denodo?
thanks in advance