select ROW_NUMBER() OVER (PARTITION BY D1.c6, D1.c7, D1.c8, D1.c9, D1.c10, D1.c11, D1.c1, D1.c3, D1.c4, D1.c13 ORDER BY D1.c6 DESC, D1.c7 DESC, D1.c8 DESC, D1.c9 DESC, D1.c10 DESC, D1.c11 DESC, D1.c1 DESC, D1.c3 DESC, D1.c4 DESC, D1.c13 DESC) as c14
Low priority … can always by removed manually
If OVER and PARTITION BY would be parsed properly, there would be a column with content bellow .
ROW_NUMBER() OVER (PARTITION BY … ) as c14
Is this what you're looking for ?
My first concern was that the message didn't show were the error was …
The exception from revj.py is more readable
__main__.MallformedSQLException: Too may dots in identifier: …
but not transmitted to the web interface.
After, It could even return
ROW_NUMBER() as c14 ,
… as c14,
ROW_NUM … as c14
This is quite a rare function, spend the minimum time with it.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.