[Solved] how to reverse a sequence [closed]

by


For Sql Sever

Select Row_Number() Over(Order By [EMP_NO] Desc) as Emp_No,
       EMP_NAME  
       from TableName
       Order By [Emp_No] Desc

Sql Fiddle Demo

For Oracle Sql Developer

Select Row_Number() Over(Order By "EMP_NO" Desc) as "Emp_No",
       "EMP_NAME"  
       from Table1
       Order By "Emp_No" Desc

Sql Fiddle Demo

18

solved how to reverse a sequence [closed]