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.
See Question&Answers more detail:os