database - ROW_NUMBER() without over in SQL

Question

Is there any way to use ROW_NUMBER() in SQL without using OVER, because I want to use sorting.

I have a Grid with multiple sortable columns with configurable rows. In my scenario order by is variable that's why I am not able to put order by using ROWNUM.

Answer 1

select ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) as number from Task order by RuleId