I want to add specific value to the row number but this statement doesn't work :
SELECT (ROW_NUMBER()+1) OVER(ORDER BY col_1 value DESC) as Row FROM table
You have to put the addition after the window function, but before the alias.
SELECT ROW_NUMBER() OVER (ORDER BY col_1, value DESC) + 1 as Row FROM table
... or, you can put it at the beginning if it seems clearer:
SELECT 1 + ROW_NUMBER() OVER (ORDER BY col_1, value DESC) as Row FROM table
I also added a comma between
value. I assume those are 2 different columns, and that it was a typo. Just mentioning for completeness.