analytic function error

Hi Team How i am suppose to implement following logic in denodo , i tried to delegate row_number() to DB but geeting execution error row_number() over (partition by ID order by idno) error ``` Finished with error: Syntax error: Exception parsing query near 'FROM' ```
user
14-03-2019 14:50:29 -0400

1 Answer

Hello, On reviewing your issue, the error is specific to incorrect syntax before the **FROM** keyword and not related to the analytic function “**Row_Number()**”. To overcome the syntax error, I would suggest you to refer to the example query like below: * SELECT ROW_NUMBER() OVER ( PARTITION BY <Field> ORDER BY <Field> ) row_number_with_partition FROM <View> Also, I would recommend you to read the section [Row_number](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/appendix/syntax_of_condition_functions/analytic_functions_window_functions#row-number) in the Virtual DataPort VQL Guide for more details. Hope this Helps!
Denodo Team
15-03-2019 02:48:18 -0400
You must sign in to add an answer. If you do not have an account, you can register here