I am getting "LISTAGG is not executable funtion" while using the fucntion to combine the data into single row using below query in denodo 8 .
query: SELECT LISTAGG(NAME,'|') WITHIN GROUP (ORDER BY NAME) FROM ( SELECT 'A' NAME UNION SELECT 'B'...
please provide a query sample example to show the function listagg.
Currently i am not able to produce syntactically correct query even though i follow the syntax.
Also please do not provide the listagg function link in ur community as i already...
Denodo 8.0 supports listagg function, but can distinct clause can be used inside the listagg?