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!