Split Database advice: ROW_NUMBER PARTITION not working still?

[eireni]

Hi all,

I tried to follow that advice that

row_number () over (partition by “x” order by “y”) as “z”

should work within the split database template. I followed the instructions to set it up, the copied the tables and queries I had in the previous database; but I’m still returning the error

"The data content could not be loaded
unexpected token: PARTITION required: ) "

when running my query. Any ideas why this might be? Do I need to reformat something?

Thanks!

[RobertG]

Missing the database you are using. “Split database” might be an external HSQLDB, an external Firebird or something else…