sequences

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]