ROW_NUMBER() without over in SQL

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.

Answers


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

Need Your Help

Purpose of a ".f" appended to a number?

c++ syntax casting

I saw "1/3.f" in a program, and wondered what the ".f" was for. So tried my own program:

What is the meaning of the ${0##...} syntax with variable, braces and hash character in bash?

bash variables syntax curly-braces

I just saw some code in bash that I didn't quite understand. Being the newbie bash scripter, I'm not sure what's going on.