Home / Q&A / The version of Denodo on which window (analytic) function of SQL can be used
You can translate the question and the replies:

The version of Denodo on which window (analytic) function of SQL can be used

<Reference> https://community.denodo.com/answers/question/details?questionId=90670000000k9oHAAQ&title=When+will+Denodo+support+analytic+functions+(i.e.+RANK%2C+NTILE%2C+PARTITION+BY....)%3F <Denodo VDP Version> 6.0 Administration tool: 6.0 20180216 VDP Server: 6.0 <Question> From which version of Denodo window (analyitc) functions can be used?
DENODO #Analytic function
user
12-01-2021 01:44:16 -0500

1 Answer

Hi Denodo currently does not support window (analytic) functions. However they can be delegated to the underlying data source if the data source supports those functions. If you have data sources that also do not support window (analytic) functions then consider using Data Movement optimisation to move the data to a data source that supports these functions. [Analytic Functions (Window Functions)](https://community.denodo.com/docs/html/browse/latest/vdp/vql/appendix/syntax_of_condition_functions/analytic_functions_window_functions#workaround-to-execute-analytic-functions) has more details on this topic. Hope this helps!
Denodo Team
12-01-2021 07:09:17 -0500
You must sign in to add an answer. If you do not have an account, you can register here