listtag in denodo

Hi How i am supose to execute following query in denod listagg (C.SHORT, '; ') WITHIN GROUP ( ORDER BY C.SHORT asc) AS DESCRIPTION
user
06-02-2019 22:46:47 -0500

1 Answer

Hi, I am able to use the [LISTAGG](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/analytic_functions_window_functions#listagg) function in Denodo. I would make sure the underlying data source supports this function because Virtual Dataport Server will delegate this function to the data source. You can also refer to a similar community question [here ](https://community.denodo.com/answers/question/details?questionId=9060g0000004EzyAAE&title=Function+similar+to+LISTAGG+in+Oracle)that talks about how to use GROUP_CONCAT as alternative in the Denodo Platform. Hope this Helps!
Denodo Team
08-02-2019 06:36:52 -0500
You must sign in to add an answer. If you do not have an account, you can register here